Jdbc

[Goh]

hi..i am new to jdbc.....and i have some doubts to clear i am now using odbc connection for sql sever.....someone ask me to use jdbc instead....(cuz later db from sql sever is going to integerate with oracle db web sever) ....why use jdbc and how do i change to jdbc? wat advantage is there?...(i am using vb application to talk to my db)

[CornedBee]

JDBC is the unified Java database API. All Java programs that access databases probably use JDBC for doing so. You cannot use JDBC from any language that doesn't use the Java VirtualMachine (e.g. VB).
The nice thing about JDBC is that you just change the connection string and you can connect to a different kind of database without changing a single line of code. This is very similar to ODBC. You can connect to every database that has a JDBC or (through Sun's JDBC-ODBC bridge) ODBC driver.

ODBC is a language-independent but (I think) Windows-only standard interface for databases. Like JDBC, it provides the same programming interface, no matter what database is at the back end. You can connect to every database that has an ODBC driver.

If you use Java, use JDBC. If you don't use Java, use something else.

[Goh]

so it means that it is impossible for me to use jdbc driver in my vb application am i right? so how wat am i suppose to do for the integeration of the two databse?( how do they talk to one another?

[CornedBee]

You can't use JDBC from VB, that's correct.


What two databases do you want to integrate? There's an ODBC driver for Oracle, if you mean that.

[Goh]

orcale db and sql sever db...