Can't connect to SQL Server 7.0
Jon Finanger
Jon.Finanger at q-free.com
Mon Mar 12 13:37:03 EST 2001
RE: [freetds] Can't connect to SQL Server 7.0you sould use the latest
version: freetds_jdbc.snapshot.jar - that solved it for me!
/Jon
-----Original Message-----
From: bounce-freetds-128054 at franklin.oit.unc.edu
[mailto:bounce-freetds-128054 at franklin.oit.unc.edu]On Behalf Of Rick
Guggemos
Sent: 12. mars 2001 18:13
To: TDS Development Group
Subject: [freetds] RE: 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')
---
You are currently subscribed to freetds as: [Jon.Finanger at q-free.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ibiblio.org/pipermail/freetds/attachments/20010312/1c7972e5/attachment.html
More information about the FreeTDS
mailing list