RE: DBD::Sybase not working with repserver

It's a non-interactive replacement for ISQL that has a lot of
customiations for our site. But since I made a major change to the
script, I don't really need to retrieve the data type any more, so I'll
take that section out.

It would be nice, however, if we had the option to use the hard coded
data types, for situations like this, at the risk of not necessarily
getting the correct info. Or maybe have it determine what type of server
it's connecting to, and then figure out how to determine the data types
based on the server type (the way Microsoft is continually changing SQL
Server, I wouldn't be surprised if they removed that stored proc one of
these days).

Regards,

Steve



Steve Wechsler | [email protected]
Sybase/SQL Server/MySQL Database Administrator
212-846-5683

MTV Networks


-----Original Message-----
From: Michael Peppler [mailto:[email protected]] 
Sent: Thursday, March 13, 2008 4:12 PM
To: Wechsler, Steven
Cc: [email protected]
Subject: Re: DBD::Sybase not working with repserver

Wechsler, Steven wrote:
> Hi.
> 
> I have a system here with the following versions installed:
> 
>   Perl            : 5.008008    (x86_64-linux-thread-multi)
>   OS              : linux       (2.6.9-42.0.3.elsmp)
>   DBI             : 1.602
>   DBD::mysql      : 3.0007
>   DBD::Sybase     : 1.08
> 
> It works fine with ASE and MS SQL Server, but when I try to retrieve 
> results from a repserver, I get this:
> 
> Msg 2056, Severity 12, State 0:
> Server 'secliverep01', Line: 0:
> Line 1, character 1: Incorrect syntax with 'sp_datatype_info'.

The typeinfo() call (in Sybase.pm) is coded to use sp_datatype_info to 
accomodate varying datatype definitions that started showing up in 12.5 
(wider varchar columns, etc).

That's why the 0.95 version works fine (datatypes are hard-coded) - as 
sp_datatype_info obviously won't work when talking to a rep server.

What does your script do?
I've used DBD::Sybase with rep server a lot, and I haven't had this 
problem...

Michael
-- 
Michael Peppler           -                 Peppler Consulting SaRL
[email protected]      -                  http://www.peppler.org
Sybase DBA/Developer      -   TeamSybase: http://www.teamsybase.com
Sybase on Linux FAQ       -   http://www.peppler.org/FAQ/linux.html