aspose file tools*
The moose likes JDBC and the fly likes Direct Me To ODBC Driver Source Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Direct Me To ODBC Driver Source" Watch "Direct Me To ODBC Driver Source" New topic
Author

Direct Me To ODBC Driver Source

David Mroczkowski
Greenhorn

Joined: Nov 07, 2002
Posts: 12
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
"The Hood"
Sheriff

Joined: Sep 29, 2000
Posts: 8521
You need to use some ODBC.
I will move this to the JDBC/ODBC forum.


"JavaRanch, where the deer and the Certified play" - David O'Meara
David Mroczkowski
Greenhorn

Joined: Nov 07, 2002
Posts: 12
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 = "jdbcdbcone"; // 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
Greenhorn

Joined: Aug 06, 2003
Posts: 28
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.
 
 
subject: Direct Me To ODBC Driver Source