Women in Technology

Article:		Getting Up To Date with JDBC API
Subject:		Remote connection to a database via JDBC-ODBC
Date:		2003-05-28 04:03:06
From:		anonymous2
How can I connect "remotely" to a relational database (e.g. a MS SQL Server 2000 database) via JDBC-ODBC? I mean, how should the "dbUrl" be written in the client application, in order to contain the hostname where the database is located and the ODBC datasource is defined? Thank you in advance.

Showing messages 1 through 2 of 2.

• Remote connection to a database via JDBC-ODBC
  2003-11-17 03:47:33  anonymous2 [View]
  
  
  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....

• Remote connection to a database via JDBC-ODBC
  2003-09-23 14:19:30  anonymous2 [View]
  
  
  i have the same problem.. could you fix it??
  
  Eli