|
|
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).
Regards,
Steve
Steve Wechsler | steven.wechsler@mtvstaff.com
Sybase/SQL Server/MySQL Database Administrator
212-846-5683
MTV Networks
-----Original Message-----
From: Michael Peppler [mailto:mpeppler@peppler.org]
Sent: Thursday, March 13, 2008 4:12 PM
To: Wechsler, Steven
Cc: sybperl-l@peppler.org
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
mpeppler@peppler.org - http://www.peppler.org
Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com
Sybase on Linux FAQ - http://www.peppler.org/FAQ/linux.html
|
