Re: Version 1.00.15 select @@spid

2017-11-09 15:06 GMT+00:00 Ganesh, Ravi Chandran <
[email protected]>:

> Hello Frediano,
>
>
>
> I am writing this email after going through your reply on the post in the
> below link.
>
> https://lists.ibiblio.org/pipermail/freetds/2016q3/030095.html
>
>
>
> We are facing similar challenge in our environment and unable to sort it
> out. We followed all the steps mentioned in the link below.
>
> http://www.orb-data.com/index.php/accessing-objectserver-
> databases-with-perl.html
>
>
>
>
>
> However still we get below error message when we try to connect to Netcool
> ObjectServer which uses Sybase database.
>
>
>
> netcool@netcoolhost:> perl -MDBI -e'my $db=DBI->connect("DBI:Sybase:server=NEW_AGP",
> netcool, netcool);print $DBI::errstr.$/'
>
> Server message number=17001 severity=10 state=0 line=0 server=NEW_AGP
> text=No SRV_OPTION handler installed. Server message number=20000
> severity=0 state=0 line=0 server=NEW_AGP text=ERROR=Parse failure on line 1
> of statement 'select @@version', at or near '@'
>
>
>
> netcool@netcoolhost:> tsql -C
>
> Compile-time settings (established with the "configure" script)
>
>                             Version: freetds v0.91.49
>
>              freetds.conf directory: /usr/local/etc
>
>      MS db-lib source compatibility: no
>
>         Sybase binary compatibility: no
>
>                       Thread safety: yes
>
>                       iconv library: yes
>
>                         TDS version: 5.0
>
>                               iODBC: no
>
>                            unixodbc: no
>
>               SSPI "trusted" logins: no
>
>                            Kerberos: no
>
>
>
> I have also attached FreeTDS log and conf files for your reference. Please
> do let me know if you need any other information to look into this case.
>
>
>
> If you could help us with this issue it would be much appreciated.
>
>
>
> Awaiting your reply!
>
>
>

This is a completely different issue. You are using 0.91 version which does
not send the "select @@spid" query and the error came from a "select
@@version" which we (FreeTDS) don't send so probably is coming from
DBI::Sybase.

Frediano