jdbc odbc connectivity without dsn creation

Asked Nov 20 '12 at 11:13

Active Nov 20 '12 at 11:32

Viewed 416 times

I am trying to make jdbc-Odbc connection without making the DSN but is throwing the exception. I am using the following code and it is throwing data source name not found no default driver specified exception.

try
{
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection con=DriverManager.getConnection(
        "Jdbc:Odbc:Driver={Microsoft Access Driver(*.mdb)}; Dbq=d:/new folder/db1.mdb;");
}
catch(Exception ex)
{   
    ex.printStackTrace();
}

suggest me whats wrong in this code.thanks in advance

edited Nov 20 '12 at 11:32

Jacob

14,463
65
207
320

asked Nov 20 '12 at 11:13

adesh

1,157
3
18
28

Have you added or included the driver in your classpath pr project location? – Jacob Nov 20 '12 at 11:24
data source name not found no default driver specified. – adesh Nov 20 '12 at 11:25
no polppan i have not included the driver in classpath nor in project location how we have to include it – adesh Nov 20 '12 at 11:26
Are you using any Tool/IDE for development? – Jacob Nov 20 '12 at 11:27
@adesh [This](http://www.oracledistilled.com/netbeans/adding-java-libraries-to-netbeans-6-9/) might be useful – Jacob Nov 20 '12 at 11:29
suggest me how to include driver in project – adesh Nov 20 '12 at 11:32
let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/19818/discussion-between-adesh-and-polppan) – adesh Nov 20 '12 at 11:34
possible duplicate of [odbc connectivity without DSN creation](http://stackoverflow.com/questions/13283813/odbc-connectivity-without-dsn-creation) – Mark Rotteveel Nov 20 '12 at 16:00
And other duplicate with accepted answer: http://stackoverflow.com/questions/13247405/run-swing-application-without-dsn-creation – Mark Rotteveel Nov 20 '12 at 16:01

jdbc odbc connectivity without dsn creation

0 Answers0