Direct Me To ODBC Driver Source

[David Mroczkowski]

I've been asked to connect to and Microsoft Access database to extract address information from a full address field. (This will eventually be moved to a MS SQL 2000 server). I've been working with Oracle ...
Can someone point in the right direction. The Access db is on my hard drive.
David

[Cindy Glass]

You need to use some ODBC.
I will move this to the JDBC/ODBC forum.

[David Mroczkowski]

Thanks, Cindy.

I hope my first message wasn't too short. I have found what I should do, but it's not working. Here is the code I'm using.

This is what I'm using for my driver = "sun.jdbc.odbc.JdbcOdbcDriver"
This is what I'm using for my url = "jdbc:odbc:Done"; // the db is in the same folder with my code.

I use

Class.forName(driver);
Connection conn = DriverManager.getConnection(url);

But...
it's not working.

I get the following exeception:
[Microsoft][ODBC Driver Manager] Data source not found and no default driver specified.

???
[ July 25, 2004: Message edited by: Marilyn de Queiroz ]

[sumana ar]

hi,
i'm no expert in Microsoft Access... try using the following code..where dsn_name is the name of the data source name(DSN) created for the database.
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc dbc:[B]dsn_name/B]" , "login_name", "password");
Statement s = con.createStatement();
--sumana.