File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes JDBC to ODBC to ODBC? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC to ODBC to ODBC?" Watch "JDBC to ODBC to ODBC?" New topic


Nick Heudecker
Ranch Hand

Joined: Jul 09, 2000
Posts: 52
This is an odd one....
I've got a Linux machine and I need to connect to a remote SQL Server database. From what I can tell, I'll have to use some type of ODBC bridge to contact the SQL Server, then use the JDBC->ODBC bridge on the Linux machine to talk to the ODBC bridge.
That's far too many bridges to have to cross.
Does anyone else have a better idea?

---<br />Co-author of "Hibernate Quickly"<br /><a href="" target="_blank" rel="nofollow"></a>
Sandeep Jain
Ranch Hand

Joined: Oct 25, 2000
Posts: 124
What i feel is, u are a bit confused . It doesnt make any difference where exactly ur database is residing. All u have to do is make a jdbc-odbc call from your program to the server.
First odbc doesnt come into picture.
When u are establishing a connection to the database You have to specify
The IP Address
The Port
Dsn Name

For this u can either go for thin Drivers or the drivers supoorted by database.

Try and Try Till u succeed
Sandeep Jain

Try and Try Till u succeed<br /> <br />Sandeep Jain
Nick Heudecker
Ranch Hand

Joined: Jul 09, 2000
Posts: 52
Okay, I think I follow you. And yes, I was confused.
Thanks for your help.
I agree. Here's the link:
subject: JDBC to ODBC to ODBC?
jQuery in Action, 3rd edition