aspose file tools*
The moose likes JDBC 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
Bookmark "JDBC to ODBC to ODBC?" Watch "JDBC to ODBC to ODBC?" New topic
Author

JDBC to ODBC to ODBC?

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="http://www.manning.com/books/peak" target="_blank" rel="nofollow">http://www.manning.com/books/peak</a>
Sandeep Jain
Ranch Hand

Joined: Oct 25, 2000
Posts: 124
Hello,
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
Username
Password

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: http://aspose.com/file-tools
 
subject: JDBC to ODBC to ODBC?