FreeTDS Development Group

[James Leigh <james AT clickmedia.ca>]

$ isql -v dbserver "James Leigh" my_password
[unixODBC]tds_connect failed
[ISQL]ERROR: Could not SQLConnect


using ethereal: there is no activity to the dbserver host.  It must be
some configuration problem.

james

On Mon, 2002-07-15 at 14:07, Peter Harvey wrote:
    What does isql show when you use -v option?
    
    Peter
    
    James Leigh wrote:
    
    >I cannot get odbc to work at all.  I could really use detailed
    >step-by-step example with field explination.  I am the only debian 
machine
    >is a feild of win32 computers.  I need to connect to an mssql server.  I
    >want to use gnome-db/gasql.  but right now I will settle for isql/sqsh or
    >anything that can connect.
    >  It uses a NT domin login, my domain user name also has a space if that
    >means something.  This is waht I have so far.  I am very confused.  I
    >could never get odbc to work in win32 or liunux and could use some help.
    >
    >/home/.james/.freetds.conf:
    >[global]
    >        # TDS protocol version
    >   tds version = 4.2
    >   initial block size = 512
    >   swap broken dates = no
    >   swap broken money = no
    >   try server login = yes
    >   try domain login = no
    >   cross domain login = no
    >[JDBC]
    >   host = 192.138.151.39
    >   port = 4444
    >   tds version = 5.0
    >[dbserver]
    >   host = 192.168.1.1
    >   port = 1433
    >   tds version = 7.0
    >   try domain logins = yes
    >   try server logins = no
    >   nt domain = MY_DOMAIN
    >/etc/odbcinst.ini:
    >[TDS]
    >Driver             = /usr/lib/odbc/libtdsodbc.so
    >Setup              = /usr/lib/odbc/libtdsS.so
    >FileUsage  = 2
    >/home/james/.odbc.ini:
    >[dbserver]
    >Driver             = TDS
    >Description        = internal database server
    >Trace              = No
    >Servername = 192.168.1.1
    >Database   = db_name
    >UID                = James Leigh
    >$ isql -v cmserver03 "James Leigh" my_password
    >[unixODBC]tds_connect failed
    >[ISQL]ERROR: Could not SQLConnect
    >
    >---
    >You are currently subscribed to freetds as: [pharvey AT codebydesign.com]
    >To unsubscribe, forward this message to 
leave-freetds-144898E AT franklin.oit.unc.edu
    >
    >
    
    
    
    
    ---
    You are currently subscribed to freetds as: [james AT clickmedia.ca]
    To unsubscribe, forward this message to 
leave-freetds-144898E AT franklin.oit.unc.edu

Attachment: signature.asc
Description: This is a digitally signed message part