query on tsql to use hostname

Abhilash_Shanmugham Abhilash_Shanmugham at Satyam.com
Mon Aug 19 19:19:10 EDT 2002


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 at 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 at 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.
**************************************************************************



More information about the FreeTDS mailing list