wood burning stoves 2.0*
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 Murach's Java Servlets and JSP this week in the Servlets 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: http://aspose.com/file-tools
subject: Direct Me To ODBC Driver Source
Similar Threads
properties file in websphere
WSAD 4.0.3 - work wrap and line numbers
Accessing Bean object?
allowing access to pages by IP address/server.xml
Network Filename