Re: Not able to connect using Sybase ASE using freeTDS

Hi,
Is the machine accessible? Is there a firewall? Is Sybase server
listens on the port it configured by freeTDS?

You have a socket error, so you need to look at all those questions...

Thank you.


On Mon, Feb 27, 2012 at 10:16 PM, Rajeevan Vaniyan
<[email protected]> wrote:
> Hi,
> Please note that the tds version displayed is 5.0 previous log was without
> TDS version overrid.
> Thanks,
> Rajeev
>
> On Tue, Feb 28, 2012 at 10:45 AM, Rajeevan Vaniyan <
> [email protected]> wrote:
>
>> Hi Guys,
>> I am not able to connect to Sybase Adaptive server 15.5 on linux using
>> freetds earlier, using freetds v0.92.dev.20111217.
>> Bypassing the configuration settings I am trying to connect to Sybase ASE
>> using command
>> TDSVER=5.0 tsql -H 10.1.33.19 -U sa -p 5000, I am getting the following
>> error.
>> locale is "en_US.UTF-8"
>> locale charset is "UTF-8"
>> using default charset "UTF-8"
>> Error 20009 (severity 9):
>>         Unable to connect: Adaptive Server is unavailable or does not exist
>>         OS error 115, "Operation now in progress"
>> There was a problem connecting to the server
>> *freetds error log show this*
>> log.c:194:Starting log file for FreeTDS 0.92.dev.20111217
>> on 2012-02-28 10:34:03 with debug flags 0x4fff.
>> iconv.c:328:tds_iconv_open(0x82f2aa8, UTF-8)
>> iconv.c:185:local name for ISO-8859-1 is ISO-8859-1
>> iconv.c:185:local name for UTF-8 is UTF-8
>> iconv.c:185:local name for UCS-2LE is UCS-2LE
>> iconv.c:185:local name for UCS-2BE is UCS-2BE
>> iconv.c:347:setting up conversions for client charset "UTF-8"
>> iconv.c:349:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion
>> iconv.c:389:preparing iconv for "ISO-8859-1" <-> "ISO-8859-1" conversion
>> iconv.c:392:tds_iconv_open: done
>> net.c:203:Connecting to 10.1.33.19 port 5000 (TDS version 5.0)
>> net.c:269:tds_open_socket: connect(2) returned "Operation now in progress"
>> net.c:315:tds_open_socket() failed
>> util.c:315:tdserror(0x82f2900, 0x82f2aa8, 20009, 115)
>> util.c:345:tdserror: client library returned TDS_INT_CANCEL(2)
>> util.c:368:tdserror: returning TDS_INT_CANCEL(2)
>> mem.c:594:tds_free_all_results()
>>
>> I  am able to connect from the database server machine with command *isql*.
>> Could any one help me on this?
>> Earlier I was able to connect using the tsql to another Sybase instance.
>> While accessing the new instance of Sybase I am getting this error.
>> Could anyone point me out that is there any configuration issues at Sybase
>> server causing this problem?
>>
>> Thanks,
>> Rajeev
>>
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds