ODBC-JDBC bridge, and ODBC configuration

[terry.williams@xxxxxxxxxxxxx (Terry Williams)]

Jose Maria Gomez Hidalgo wrote:

> Dear all
>
> I am working on a project that requires to access to a MS Access database.
> A friend has told me that I have to configure ODBC, and to install a
> JDBC/ODBC bridge. I know how to work with JDBC, but some help on the other
> two topics is wellcome. Pointers to detailed description of the
> installation and configuration process?
>
> Thanx
>
>         Jose Maria
>
> ---
> To unsubscribe, mail advanced-java-unsubscribe@xxxxxxxxxxxxxxxx
> To get help, mail advanced-java-help@xxxxxxxxxxxxxxxx

Hi,
    this really is a no brainer. If you have access you will have the obdc
driver for access. I'm assuming you have WinNT or 98 or 95. Go into the
control panel and click the ODBC 32 icon - give your access source a DSN
(data source name). Restart your machine.

The JDBC:ODBC machine takes the DSN as the first parameter, with "" & "" for
user name & password  (which are obviously filled if you have specified a
username/password on the access database. Off you go, easy as pie although I
really don't recommend the jdbc:odbc driver for really efficient apps. Its
more for proof of concept and demos than anything else.

Terry


---
To unsubscribe, mail advanced-java-unsubscribe@xxxxxxxxxxxxxxxx
To get help, mail advanced-java-help@xxxxxxxxxxxxxxxx