aspose file tools*
The moose likes JDBC and the fly likes Can I connect to MS SQL Server using OLE-DB in Java Programs?? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Can I connect to MS SQL Server using OLE-DB in Java Programs??" Watch "Can I connect to MS SQL Server using OLE-DB in Java Programs??" New topic
Author

Can I connect to MS SQL Server using OLE-DB in Java Programs??

Farooq Ali
Ranch Hand

Joined: Sep 30, 2000
Posts: 43
Another question..
Can MS Ole-Db be used somehow instead of the standard ODBC/DSN technique?? to connect to a java program??
FArooq
Robert Brunner
Ranch Hand

Joined: Jul 18, 2001
Posts: 49
Originally posted by Farooq Ali:
Another question..
Can MS Ole-Db be used somehow instead of the standard ODBC/DSN technique?? to connect to a java program??
FArooq

Hi Farooq,
I have never heard/seen it done, although maybe some of the type 4 JDBC drivers do that directly. Java programs expect to talk to a database using the JDBC API (even JDO is layered on top of JDBC for SQL data stores). The only way ODBC is used is with the JDBC-ODBC bridge.
Cheers,
Robert
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Can I connect to MS SQL Server using OLE-DB in Java Programs??