freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: how to establish a connect to the sql server dabatase using JDBC

From: Bob Kline <bkline AT rksystems.com>
To: TDS Development Group <freetds AT franklin.oit.unc.edu>
Subject: Re: how to establish a connect to the sql server dabatase using JDBC
Date: Mon, 13 Aug 2001 19:32:04 -0400 (EDT)

On Sun, 12 Aug 2001, xue yuhao wrote:

> I have a data source "learning" in SQL Server. What is the syntax to
> connect to this database? My SQL Server is installed under the
> directory C:\Mssql7. Is it required to configure the system DSN
> before using it?

System DSNs are used by ODBC. The JDBC driver does not use ODBC. It
connects directly to the SQL Server using TCP/IP sockets. Please read
the README file[1] for the driver for the syntax used for the URL when
connecting to the server. You can also find sample code in the FAQ[2]
document which can be easily adapted for testing the connection to your
server.

[1] ftp://freetds.internetcds.com/pub/freetds_jdbc/README
[2] http://www.freetds.org/faq.html#jdbc%20test

--
Bob Kline
mailto:bkline AT rksystems.com
http://www.rksystems.com

how to establish a connect to the sql server dabatase using JDBC, xue yuhao, 08/12/2001
- <Possible follow-up(s)>
- Re: how to establish a connect to the sql server dabatase using JDBC, Bob Kline, 08/13/2001
- Re: how to establish a connect to the sql server dabatase using JDBC, xue yh, 08/27/2001