Skip to Content.
Sympa Menu

freetds - Re: [freetds] connection to SQL server 2008 express

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Mahendra T <mahendra.t AT tcs.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Cc: freetds-bounces AT lists.ibiblio.org
  • Subject: Re: [freetds] connection to SQL server 2008 express
  • Date: Tue, 23 Feb 2010 20:07:03 +0530

> 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 <ddick AT cpan.org>
To:
FreeTDS Development Group <freetds AT lists.ibiblio.org>
Date:
02/23/2010 03:32 PM
Subject:
Re: [freetds] connection to SQL server 2008 express
Sent by:
freetds-bounces AT lists.ibiblio.org



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
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






Archive powered by MHonArc 2.6.24.

Top of Page