Re: Can't connect to Sybase Rep server
- From: matthew.persico@xxxxxxxxx (Matthew Persico)
- Date: Mon, 27 Feb 2006 16:58:55 -0500
On 2/27/06, Mark Anderson <manderso@xxxxxxxxxxxxxx> wrote:
This is not a very helpful answer, but are you sure this is worth
trying? A Replication Server is not an Adaptive Server Enterprise.
Admittedly they both use the same Tabular Data Stream networking
protocol, but they have very different command languages. A Rep Server
isn't even a database server. Are you sure it is reasonable to expect a
DBI driver for Sybase ASE to work correctly with Rep Server?
Yes. We have a current production job that does exactly this. The
problem appears to be in our development environment where we updated
the DBI and DBD::Sybase version.
But your point does ring a bell. A rep server is a different beast
than an ASE server. The error message (see below) stated that the
server basically didn't know what to do with "select". I bet that
DBD::Sybase 1.07 is making a call to the database to get some
information that was not made in DBD::Sybase 1.00. That would explain
the problem. I guess a diff of the versions is in order. I'll try it
later tonight unless Michael chimes in with a eureka moment before
then... :-)
Maybe Sybperl is the way to go if you want your perl program to talk to
a Rep Server.
Good luck,
Mark
Matthew Persico wrote:
This simple test program:
use strict;
use warnings;
use DBI;
my $dbh = DBI->connect('dbi:Sybase:server=REPP', 'REPP_login',
'REPP_passwd', {RaiseError => 1});
my $dummy = 6;
causes this:
Server message number=17001 severity=10 state=0 line=0 server=REPP
text=No SRV_OPTION handler installed.OpenClient message: LAYER = (1)
ORIGIN = (1) SEVERITY = (1) NUMBER = (183)
Server REPP, database
Message String: ct_options(): user api layer: external error: An error
was returned from the server while setting the options, check the
server message for details.
Server message number=2056 severity=12 state=0 line=0 server=REPP
text=Line 1, character 8: Incorrect syntax with 'select'.
persicom@nydux-ast401 (DEV, uid=8030(persicom) gid=200(develop) depth=0)
using Perl 5.6.1, DBI 1.48 and DBD::Sybase 1.07.
However, when using Perl 5.6.1, DBI 1.37 and DBD::Sybase 1.00, I get
no error message.
What DBI trace flags/envars do I neet to set in order to diagnose this?
--
Matthew O. Persico
--
Mark Anderson mailto:manderso@xxxxxxxxxxxxxx
Alaska Satellite Facility phone: (907) 474-5789
Geophysical Institute fax: (907) 474-6441
University of Alaska Fairbanks
903 Koyukuk Dr., PO Box 757320
Fairbanks, Alaska 99775-7320
It's better to ask a stupid question than to make a stupid assumption.
--
Matthew O. Persico
.
- References:
- Can't connect to Sybase Rep server
- From: Matthew Persico
- Re: Can't connect to Sybase Rep server
- From: Mark Anderson
- Can't connect to Sybase Rep server
- Prev by Date: Re: Connect to Oracle
- Next by Date: RE: A common perl script for different database platforms
- Previous by thread: Re: Can't connect to Sybase Rep server
- Next by thread: Re: Can't connect to Sybase Rep server
- Index(es):
Relevant Pages
|
