Skip to Content.
Sympa Menu

freetds - Re: mssql connection

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: James Leigh <james AT clickmedia.ca>
  • To: TDS Development Group <freetds AT franklin.metalab.unc.edu>
  • Subject: Re: mssql connection
  • Date: 15 Jul 2002 14:12:00 -0400

$ 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




Archive powered by MHonArc 2.6.24.

Top of Page