freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "James Leigh" <james AT clickmedia.ca>
- To: freetds AT franklin.oit.unc.edu
- Subject: mssql connection
- Date: Mon, 15 Jul 2002 14:01:10 -0400
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
-
mssql connection,
James Leigh, 07/15/2002
- <Possible follow-up(s)>
- Re: mssql connection, Peter Harvey, 07/15/2002
- Re: mssql connection, James Leigh, 07/15/2002
- Re: mssql connection, Eric Deutsch, 07/15/2002
- Re: mssql connection, Brian Bruns, 07/15/2002
- Re: mssql connection, James Leigh, 07/15/2002
- Re: mssql connection, Brian Bruns, 07/15/2002
- Re: mssql connection, James Leigh, 07/15/2002
Archive powered by MHonArc 2.6.24.