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-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.

Full Threads Newest First

Showing messages 1 through 2 of 2.

  • 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
  • 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....