It's not a secret anymore!
The moose likes Beginning Java and the fly likes JDBC, ODBC, Drivers, etc. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Beginning Java
Bookmark "JDBC, ODBC, Drivers, etc." Watch "JDBC, ODBC, Drivers, etc." New topic

JDBC, ODBC, Drivers, etc.

Chris Funkhouser

Joined: Dec 10, 2001
Posts: 12
I've been using the jdbc dbc bridge driver to create an application that connects to an Access database. I'm deploying it using Web Start.
When I run it on my local machine, it works fine. When I try it on a different machine, it looks for the DSN on that machine and doesn't find it.
What I've read in this forum is that I need to get a different driver specifically for Access (or perhaps SQL Server, if I decide to port my data there). But I'm clueless about drivers. Can someone help me out with some step-by-step instructions about what type of driver to get, what it might cost, how to install it, etc.?
Junilu Lacar

Joined: Feb 26, 2001
Posts: 6529

No special drivers are needed: the jdbc dbc driver should work fine. What you probably need to do is to configure an ODBC Data Source Name (DSN) on the other machine (the one that you say the application is not working on). The ODBC Data Source Administrator is in the Windows Control Panel.
[This message has been edited by JUNILU LACAR (edited December 15, 2001).]

Junilu - [How to Ask Questions] [How to Answer Questions]
karl koch
Ranch Hand

Joined: May 25, 2001
Posts: 388
i never used odbc.....but make sure you are not connecting to localhost on the other machine. use ip/name of the server.

I agree. Here's the link:
subject: JDBC, ODBC, Drivers, etc.
It's not a secret anymore!