Skip to Content.
Sympa Menu

freetds - Re: mssql connection

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Brian Bruns" <camber AT ais.org>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: mssql connection
  • Date: Mon, 15 Jul 2002 14:30:44 -0400


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




Archive powered by MHonArc 2.6.24.

Top of Page