File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Direct Me To ODBC Driver Source" Watch "Direct Me To ODBC Driver Source" New topic

Direct Me To ODBC Driver Source

David Mroczkowski

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.
Cindy Glass
"The Hood"

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

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

Connection conn = DriverManager.getConnection(url);

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

Joined: Aug 06, 2003
Posts: 28
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.
Connection con = DriverManager.getConnection("jdbc dbc:[B]dsn_name/B]" , "login_name", "password");
Statement s = con.createStatement();
I agree. Here's the link:
subject: Direct Me To ODBC Driver Source
Similar Threads
WSAD 4.0.3 - work wrap and line numbers
allowing access to pages by IP address/server.xml
Accessing Bean object?
Network Filename
properties file in websphere