Click to See Complete Forum and Search --> : JDBC-Databases-ODBC-Java


Schardl Robert
April 22nd, 1999, 02:58 AM
Hy!

I have the following problem:
I've programmed a Java-Program, which reads records from a database.
On the server i've installed an odbc-driver for ms-access.
When the program runs on the server, i can read any records, but when the program runs on
the client, i must install the odbc-driver on the client too or i get the following error-message:
"no suitable driver". How can i solve this problem without installing an odbc-driver on the client?

I want to have the following configuration:
SERVER -> ms-access database an the driver
CLIENT -> no driver

In Perl i can do this with Win32::ODBC.

All i know is that there are 4 driver-models:
1.) JDBC-ODBC-Bridge: client must have installed an odbc-driver;
2.) JDBC-Native: client must have installed an driver;
============================================================
3.) JDBC-Network-Driver (Three Tier): THAT IS I WANT TO KNOW, HOW ??
============================================================
4.) Direct-Connection;

I hope, anyone can help me.

Thanks
Robert Schardl