my dog learned polymorphism
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

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
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?
It's not a secret anymore!