JDBC, NO SUITABLE DRIVER,3 TIER

[Schardl Robert]

Hy!

Nobody at the Java-DiscussionBoard can help me, maybe here is anybody ....

I want to connect to a ms-access-database.
I do this with the following connectString:
"jdbc:odbc:IE_Developer;USER=user;SERVER:192.124.155.20", where IE_Developer is my System-DSN.
DriverClass:
"sun.jdbc.odbc.JdbcOdbcDriver".

If i trie it on MY workstation, everything works!
BUT if i trie it on an other workstation, it fails because of the driver, which is not installed on the other
machine. The errorMessage is the following->"No suitable driver".

So i want to trie it with the JDBC-Network-Driver-Modell (Three Tier).
BUT HOW CAN I DO THIS????????

Or if you have an other idea, PLEASE ...... HELP ME!

Thanks for helping and sorry for my english!
Robert Schardl

[Masaaki]

Hi.

As long as I read your code, you use JDBC-ODBC bridge.
So, you just set ODBC driver correct as wellas
the database name to ODBC of the other machine.

Your approach is not a true JDBC driver.

HTH.
-Masaaki Onishi-

[Schardl Robert]

Hy!
Tanks for helping me, but i don't want to set an ODBC-Driver.
The client does not have any odbc-drivers on his machine.
Only the server has installed odbc-drivers.
So, how can i do this?

Thanks
Robert Schardl