Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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





Archive powered by MHonArc 2.6.24.

Top of Page