FreeTDS Development Group

["Rick Guggemos" <guggemos AT nortelnetworks.com>]

Title: RE: [freetds] Can't connect to SQL Server 7.0

Verify that the connection that you have is a "standard" connection NOT a "trusted" connection.

I verify this by established a ODBC data source ( user ) with ip address, username and password.

The SQL Server that you are using has the option for:

1) standard only
2) trusted only
3) both

I would recommend the "both" option.

After the ODBC data source is established, use Microsoft Query ( an "add in" with Office 2000 ) and
select

data -> get external data -> new data query

Rick

-----Original Message-----
From:   Zeljko Trogrlic [SMTP:zeljko AT technologist.com]
Sent:   Friday, March 09, 2001 2:28 PM
To:     TDS Development Group
Subject:        [freetds] Can't connect to SQL Server 7.0

I'm using freetds_jdbc.jar with SQL Server 7.0.

URL: jdbc:freetds:sqlserver://adder/artist

When I try to connect to the database, driver throws exception. I can
connect with other JDBC drivers . I'm using properties to configure
connection settings (user & password).

Here is exception, any ideas?
I can't find correct source to debug this (no Constructors class!).

java.sql.SQLException
        at com.internetcds.jdbc.tds.Constructors.newConnection
Constructors.java:305)
        at com.internetcds.jdbc.tds.Driver.connect(Driver.java:257)
        at java.sql.DriverManager.getConnection(DriverManager.java:517)
        at java.sql.DriverManager.getConnection(DriverManager.java:146)

---
You are currently subscribed to freetds as: [guggemos AT nortelnetworks.com]
To unsubscribe, forward this message to $subst('Email.Unsub')