Re: Can't connect to Sybase Rep server

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?

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.


.

Relevant Pages

  • mysql 4.1x and DBD::mysql (and mysqlPP)
    ... 4.1.7-nt for testing and now I can't connect to the server from perl. ... DBI is 1.45 ... consider upgrading MySQL client ...
    (perl.dbi.users)
  • Re: DBI and DBI::Oracle packages configuration
    ... The problem is that the server doesn't have DBI and ... >perl, c, etc. ... The installation won't touch overall system ...
    (comp.lang.perl)
  • Re: DBI and DBI::Oracle packages configuration
    ... The problem is that the server doesn't have DBI and ... >perl, c, etc. ... The installation won't touch overall system ...
    (comp.lang.perl.modules)
  • RE: Can not get DBI to work on a windows XP machine
    ... What's missing from your message is what Perl you are using. ... I'll also presume that you used the PPM tool to install DBI from an ActiveState repository. ... I've installed DBD::ODBC on an XP and have successfully accessed an MSDE server. ... I have two computers one a Windows XP computer and the other a Windows ...
    (perl.dbi.users)
  • Fwd: Cant connect to Sybase Rep server
    ... Can't connect to Sybase Rep server ... BTW - which version of DBI are you using? ... Objet: Re: Can't connect to Sybase Rep server ... Toute utilisation de ce ...
    (perl.dbi.users)