FreeTDS Development Group

[Peter Harvey <pharvey AT codebydesign.com>]

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 $subst('Email.Unsub')