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 ADO connection and JAVA --- Pls. HELP!!! 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 "ADO connection and JAVA --- Pls. HELP!!!" Watch "ADO connection and JAVA --- Pls. HELP!!!" New topic

ADO connection and JAVA --- Pls. HELP!!!

lydia westland
Ranch Hand

Joined: Feb 24, 2002
Posts: 72
Hi Ranchers,
I have a Java application, whose database connection is through ODBC to SQL server. But this project is going to be integrated with another project; that project is using ADO connection to SQL server 7.0. May I know if Java application can use ADO connection as well? then I don't have much to change.
Thank you so much

Lydia<br />~~~~~~~~~~~~<br />I love Italy team.
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17276

Well the ADO connection is just a connection to the Database, that's what JDBC is for, and you can use the JDBC-ODBC Bridge if you want to keep use the same DSN on the users machine.
I am assuming VB or VB like code for the other App using the ADO Connection.
There is also JIntegra which is a COM to Java bridge, which would allow you to use it.
But again I suggest sticking with JDBC to connect to your SQL Server.
But also note, I am not an expert in this subject, I just know ADO and I know JDBC, I just never heard of using Java and ADO together, its like putting Yugo car parts into a Ferrari.

Perfect World Programming, LLC - iOS Apps
How to Ask Questions the Smart Way FAQ
sanz nsgha
Ranch Hand

Joined: Jan 18, 2002
Posts: 42
lydia, you can use ADO with Java using third party drivers. i used infoZoom's ADO driver and got quite good results in some cases. here's the link where you can download a trial copy:
good luck!
I agree. Here's the link:
subject: ADO connection and JAVA --- Pls. HELP!!!
It's not a secret anymore!