[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