Skip to Content.
Sympa Menu

freetds - query on tsql to use hostname

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Abhilash_Shanmugham <Abhilash_Shanmugham AT Satyam.com>
  • To: TDS Development Group <freetds AT franklin.metalab.unc.edu>
  • Subject: query on tsql to use hostname
  • Date: Mon, 19 Aug 2002 18:19:10 +0530


I am trying to use the tsql utility that comes with the freeTDS

MY scenario is like this
I have MS SQL 2000 running on my network
and I have freetds installed in RedHat 7.2 System
if I try
[root@localhost bin]# ./tsql -Sccr3mcg109 -H172.18.57.40 -p1433 -Usa -Pgnu
I am able to connect and able to query
well now if i try with the host name

[root@localhost bin]# ./tsql -Sccr3mcg109 -Usa -Pgnu
Unknown marker: 0!!
There was a problem connecting to the server

My entry in the /usr/local/freetds/
[ccr3mcg109]
host=172.18.57.40
port = 1433
tds version = 7.0
try domain logins = no
try server logins = yes
nt domain = ccr

I looked up the /tmp/freetds.log

2002-08-19 12:19:47 Connecting addr 172.18.57.40 port 1433
2002-08-19 12:19:47 inside tds_process_login_tokens()
2002-08-19 12:19:47 inside tds_process_default_tokens() marker is 0

Can you tell me where I have made a mistake in the freetds.conf file entry .


Cheers and Regards
Abhilash


**************************************************************************
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
**************************************************************************




Archive powered by MHonArc 2.6.24.

Top of Page