[freetds] connection to SQL server 2008 express

Mahendra T mahendra.t at tcs.com
Thu Feb 25 08:24:54 EST 2010


Hi,
I am able to connect to the database by mentioning the port number in the 
query,
like TDSPORT=1433 TDSDUMP=/home/user/freetds.log tsql -S IP_Address -U 
user_name
but if it is trying to connect at port 4000 if I don't mention the 
TDSPORT, though the port is set to 1433 in freetds.conf file.
Also I am not able to connect to SQL server from perl, it may be trying to 
connect at port 4000.

Any ideas pls?

Mahendra




From:
"James K. Lowden" <jklowden at freetds.org>
To:
FreeTDS Development Group <freetds at lists.ibiblio.org>
Date:
02/25/2010 08:21 AM
Subject:
Re: [freetds] connection to SQL server 2008 express
Sent by:
freetds-bounces at lists.ibiblio.org



Mahendra T wrote:
> 
> Dynamic ports were enabled in the SQL server configuration, It started 
> working after I disabled them and mentioned 1433 as TCP/IP port.

The current snapshot has (as will the next release) a feature to print
instance information with tsql.  Try 

                 $ tsql -LH hostname

Hrm.  Just noticed if hostname is not valid, you get no port information
(of course) but also no error message.  That's why releases take longer
than snapshots....

--jkl


_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you





More information about the FreeTDS mailing list