Re: Can't connect to Sybase Rep server
- From: michael.peppler@xxxxxxxxxxxxxx (Michael Peppler)
- Date: Tue, 28 Feb 2006 07:54:07 +0100
This is a known problem, and has been fixed in either 1.07 or 1.07_01.
DBD::Sybase tries to see if chained transactions are supported at startup,
and tries to find the @@version of the server. Both of these requests fail
against a replication server, but the failure is expected, so should simply
be hidden from the user...
Michael
Extranet
matthew.persico@xxxxxxxxx - 27/02/2006 20:39
To: dbi-users, Michael PEPPLER
cc:
Subject: Can't connect to Sybase Rep server
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
This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and
immediately notify the sender. Any use not in accord with
its purpose, any dissemination or disclosure, either whole
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message.
BNP PARIBAS (and its subsidiaries) shall (will) not
therefore be liable for the message if modified.
---------------------------------------------
Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses
destinataires et sont confidentiels. Si vous recevez ce
message par erreur, merci de le detruire et d'en avertir
immediatement l'expediteur. Toute utilisation de ce
message non conforme a sa destination, toute diffusion
ou toute publication, totale ou partielle, est interdite, sauf
autorisation expresse. L'internet ne permettant pas
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce
message, dans l'hypothese ou il aurait ete modifie.
.
- Prev by Date: RE: Connect to Oracle
- Next by Date: RE : Can't connect to Sybase Rep server
- Previous by thread: Re: Can't connect to Sybase Rep server
- Next by thread: Connect to Oracle
- Index(es):
Relevant Pages
|
