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