Connecting natively to db2,MSSql,oracle, and access

Dear all,

Did anyone know the way to connect to those different databases natively (db2,MSSql,oracle, and access).

Thanks alot for your help

best regards

Aabed

More of a JDBC question here than a Servlets question, so I am going to move this to the JDBC forum.

Mark

Can you define 'natively'? It sounds like you're just looking for a type-4 driver for each database.

I mean, I'd like to connect to each one without using the odbc of the system. I want to connect to the database directly without using the odbc.

Hope you get my point

Thanks and best regards

Aabed

You only connect to the database using ODBC if you use the Type-1 driver also known as the jdbc-odbc bridge. Types 2 and 3 are a mixture (you can search the forum for a more complete definition), but Type-4 drivers are Java libraries usually developped by the database vendor which allows Java code to talk directly to the database ie no ODBC, no client-side installations, all Java and the Database.

Dave

I think if you want your application to talk directly o the database without JDBC or ODBC, you will have to search for documentation of each of those databases

But why would you want to do that? Are you trying to use something specific that is available in the vendor's native API? Or are you trying to do regular database access? Most major database vendors supply their own JDBC drivers, and I guess a JDBC driver implemented by the database vendor would be much more efficient than anything that I can come up with

Dear Jayesh Lalwani,

So can you help me to know the native driver for each of those databases.

Thanks again for help

Best regards

Aabed