FreeTDS Development Group

["Brian Bruns" <camber AT ais.org>]

Start by getting sqsh working, it's a whole lot simpler and go from there.
 If the servers are using domain logins, we may have a problem since we
have been as yet unable to make that work.  *However* seeing as you have a
working ethereal configuration, if you'd care to put some elbow grease in,
we may be able to make a go of it.  Otherwise, if the servers are in mixed
mode, then there shouldn't be any problem.

Brian

> 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