The moose likes JDBC and the fly likes JDBC_ODBC bridge Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Java » JDBC
Reply Bookmark "JDBC_ODBC bridge" Watch "JDBC_ODBC bridge" New topic
Author

JDBC_ODBC bridge

sarah Marsh
Ranch Hand

Joined: Mar 06, 2001
Posts: 282
Hello:
Could you please suggest the good JDBC-ODBC bridge
that is not expensive for production use?
Thanks in advance,
Sarah
Dave Vick
Ranch Hand

Joined: May 10, 2001
Posts: 3244
Sarah
What's wrong with the one that comes with the SDK? It is automatically installed for you and is in your class path along with the rest of the standard APIs.
Just use:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
To instantiate it and have it register itself with the driver manager.


Dave
Jag Sharma
Greenhorn

Joined: Nov 09, 2001
Posts: 10
I want to do the same the Sarah wants to do. I am getting the following error:
java.sql.SQLException: [Microsoft][ODBC Driver Ma
nager] Data source name not found and no default driver specified
Thanks
Jag
Dave Vick
Ranch Hand

Joined: May 10, 2001
Posts: 3244
What does your code look like?
sarah Marsh
Ranch Hand

Joined: Mar 06, 2001
Posts: 282
Hello Dave,

What's wrong with the one that comes with the SDK? It is automatically installed for you and is in your class path along with the rest of the standard APIs.

How to do the config on Solaris? I made it works
on NT but Solaris, I got "No suitable driver"?
Please help!
Sarah
Dave Vick
Ranch Hand

Joined: May 10, 2001
Posts: 3244
Sarah
Do you have the ful SDK loaded not just a JVM? Make sure your class path and everything is correct including case on Solaris.
sarah Marsh
Ranch Hand

Joined: Mar 06, 2001
Posts: 282
Thanks all. I had the running time library
setting up wrong.
Thanks again!
 
 
subject: JDBC_ODBC bridge
 
Threads others viewed
dynamically change gui components attributes
coding and kung fu
WA #1.....word association
Design Patterns for DAO & VO
calling a function in VB dll from java
IntelliJ Java IDE