Skip to Content.
Sympa Menu

freetds - RE: Can't connect to SQL Server 7.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Rick Guggemos" <guggemos AT nortelnetworks.com>
  • To: 'TDS Development Group' <freetds AT franklin.oit.unc.edu>
  • Subject: RE: Can't connect to SQL Server 7.0
  • Date: Mon, 12 Mar 2001 12:13:05 -0500

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')




Archive powered by MHonArc 2.6.24.

Top of Page