Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: "Wechsler, Steven" <Steven dot Wechsler at mtvstaff dot com>
Subject: RE: DBD::Sybase not working with repserver
Date: Mar 13 2008 8:19PM

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).



Steve Wechsler |
Sybase/SQL Server/MySQL Database Administrator

MTV Networks

-----Original Message-----
From: Michael Peppler [] 
Sent: Thursday, March 13, 2008 4:12 PM
To: Wechsler, Steven
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 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 

Michael Peppler           -                 Peppler Consulting SaRL      -        
Sybase DBA/Developer      -   TeamSybase:
Sybase on Linux FAQ       -