Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Farooq Ali
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 49
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic