JDBC

[Kiran Prabhu]

hi
Can anybody?

How can i find what kind of JDBC-ODBC bridge drivers intalled on my system.
Also where can i find these drivers.
Oracle and access drivers could be use full for me.

bye
kiran

[Dan Adamson]

"Kiran Prabhu" <connectprabhu@hotmail.com> wrote:
>hi
>Can anybody?
>
>How can i find what kind of JDBC-ODBC bridge drivers intalled on my system.
>Also where can i find these drivers.
>Oracle and access drivers could be use full for me.
>
>bye
>kiran
>
>
The sun.jdbc.odbc.JdbcOdbcDriver was installed with your recent JDK. This
can access Oracle. In the case of the jdbc-odbc bridge though, the problem
is with the user's computer. Each user must have an ODBC data source defined
on their machine which points to the database you're accessing. If you're
using Windows NT, this is in the Control Panel (ODBC Data Sources). I have
not been able to get the jdbc-odbc bridge to work with file-based data sources.
I'm not sure why that is, because it should work, then you could pass the
connection information to the user's computer at runtime. Also, there are
drivers out there which are specific to Oracle and Access, but you don't
want to use those, unless you depend on some special function of Oracle or
Access which is not part of the ODBC specification. Feel free to contact
me directly if you're having trouble, I'm a very helpful guy, and I've just
been through this nightmare in my company...

dna_man@yahoo.com
dan.adamson@wallst.com

[Dan Adamson]

"Kiran Prabhu" <connectprabhu@hotmail.com> wrote:
>hi
>Can anybody?
>
>How can i find what kind of JDBC-ODBC bridge drivers intalled on my system.
>Also where can i find these drivers.
>Oracle and access drivers could be use full for me.
>
>bye
>kiran
>
>
You can also try this in your code, and if you get a ClassNotFoundException,
then there's a problem.

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

That's the code to register the jdbc-odbc bridge driver.