Re: Not able to connect using Sybase ASE using freeTDS

Thank you Igor. The problem was with firewall settings.
Now it works.
Thanks,
Rajeev

On Tue, Feb 28, 2012 at 1:21 PM, Igor Korot <[email protected]> wrote:

> 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
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>