File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC to ODBC to ODBC?

 
Nick Heudecker
Ranch Hand
Posts: 52
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Sandeep Jain
Ranch Hand
Posts: 124
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Nick Heudecker
Ranch Hand
Posts: 52
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic