Re: connection to SQL server 2008 express

> Thanks David,
> I have tried setting the environment variables, still no luck.

> so what do you see when you set the TDSDUMP environment variable?

> some documentation for TDSDUMP is at 
> http://www.freetds.org/userguide/logging.htm

Log looks like this.

log.c:190:Starting log file for FreeTDS 0.82
        on 2010-02-23 19:59:57 with debug flags 0x4fff.
iconv.c:197:names for ISO-8859-1: ISO-8859-1
iconv.c:197:names for UTF-8: UTF-8
iconv.c:197:names for UCS-2LE: UCS-2LE
iconv.c:197:names for UCS-2BE: UCS-2BE
iconv.c:363:iconv to convert client-side data to the "646" character set
iconv.c:516:tds_iconv_info_init: converting "US-ASCII"->"UCS-2LE"
net.c:210:Connecting to IP_Adress port 1433 (TDS version 8.0)
net.c:264:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:299:getsockopt(2) reported: Connection refused
util.c:334:tdserror(58ca0, 570f8, 20009, 150)
util.c:368:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:389:tdserror: returning TDS_INT_CANCEL(2)
net.c:310:tds_open_socket() failed
mem.c:563:tds_free_all_results()

I have talked to our network administrator, he says that he has given all 
the access and opened the required ports.
I could connect to the database instance at 1433 port from the same 
machine where it is installed. 
Any other possibilities for the error?

Mahendra



From:
David Dick <[email protected]>
To:
FreeTDS Development Group <[email protected]>
Date:
02/23/2010 03:32 PM
Subject:
Re: [freetds] connection to SQL server 2008 express
Sent by:
[email protected]



On 23/02/10 20:50, Mahendra T wrote:
> On 23/02/10 19:51, Mahendra T wrote:
>> I have gone to the directory where tsql is present and tried connecting
> to
>> SQL server 2008 express which is installed on a windows machine with 
the
>> following command.
>>
>> tsql -H hostname -p 1433 -U User_name
>> locale is "C"
>> locale charset is "646"
>> Password:
>> There was a problem connecting to the server
>
>> Take a look at http://www.freetds.org/userguide/envvar.htm
>> and try setting TDSVER to 8.0
>
> Thanks David,
> I have tried setting the environment variables, still no luck.
>
> Mahendra

so what do you see when you set the TDSDUMP environment variable?

some documentation for TDSDUMP is at 
http://www.freetds.org/userguide/logging.htm
_______________________________________________
FreeTDS mailing list
[email protected]
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