By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,497 Members | 2,113 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,497 IT Pros & Developers. It's quick & easy.

no suitable driver found exception when getting connection with access

P: n/a
hi,
i m trying to connect ms access with jdbc odbc bridge.
forName(sun.jdbc.odbc.JdbcOdbcDriver) is working well.
when i m trying 2 get connection with

con.getConnection(jdbc.odbc.office);
where office is a dsn 4 ms access setup by odbc.
i m getting exception that "NO SUITABLE DRIVER FOUND".
WAT IS THE PROBLEM.
PLZ HELP ME.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ta*************@hotmail.com wrote in
news:11*********************@g47g2000cwa.googlegro ups.com:
i m trying to connect ms access . . .
No, Access is not involved. You're using Jet.

You may have used Access to create the MDB file, but that's the last
involvement Access had in the process.
. . . with jdbc odbc bridge.
forName(sun.jdbc.odbc.JdbcOdbcDriver) is working well.
when i m trying 2 get connection with

con.getConnection(jdbc.odbc.office);
where office is a dsn 4 ms access setup by odbc.
i m getting exception that "NO SUITABLE DRIVER FOUND".


Is Jet installed on the machine from which you're trying to make the
connection? Remember, Jet is *not* a server database engine -- there
is no processing going on remotely, everything happens on the local
machine.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.