Skip to Content.
Sympa Menu

freetds - Re: [freetds] Version 1.00.15 select @@spid

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: "Ganesh, Ravi Chandran" <ravi.chandran.ganesh AT volvocars.com>
  • Cc: "freetds AT lists.ibiblio.org" <freetds AT lists.ibiblio.org>, "Pollard, Robin" <robin.pollard AT volvocars.com>, "chandranravi.1984 AT gmail.com" <chandranravi.1984 AT gmail.com>
  • Subject: Re: [freetds] Version 1.00.15 select @@spid
  • Date: Fri, 10 Nov 2017 12:49:42 +0000

2017-11-09 15:06 GMT+00:00 Ganesh, Ravi Chandran <
ravi.chandran.ganesh AT volvocars.com>:

> Hello Frediano,
>
>
>
> I am writing this email after going through your reply on the post in the
> below link.
>
> https://lists.ibiblio.org/sympa/arc/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



  • Re: [freetds] Version 1.00.15 select @@spid, Frediano Ziglio, 11/10/2017

Archive powered by MHonArc 2.6.24.

Top of Page