Women in Technology

Hear us Roar



Article:
  Getting Up To Date with JDBC API
Subject:   Remote connection to a database via JDBC-ODBC
Date:   2003-11-17 03:47:33
From:   anonymous2
Response to: Remote connection to a database via JDBC-ODBC

Hi,
I have the following suggestion(s)
a) part of the Property File:
jdbc.drivers=sun.jdbc.odbc.JdbcOdbcDriver
jdbc.url=jdbc:odbc:xxx


xxx ... Name of the ODBC entry (client)


b) ODBC entry
Generation of the ODBC entry under WinXX (Win2000, WinNt, ...) is done by "Administrative Tools / Data Sources"
--> Add User or System DSN
--> Search the host from the dropdown list
and select or write the host in
--> Fill in the other points


Hope it helps....