File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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?
 
Similar Threads
need help
How to Connect SQL Server with java using JDBC
What is ODBC
connet to sql server and run query
jdbc odbc bridge