On 2/28/06, Matthew Persico <[EMAIL PROTECTED]> wrote:
> > -------- Message d'origine--------
> > De: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]
> > Date: mar. 28.02.2006 07:54
> > À: [EMAIL PROTECTED]
> > Cc: dbi-users@perl.org
> > Objet: Re: Can't connect to Sybase Rep server
> >
> >
> >
> > This is a known problem, and has been fixed in either 1.07 or
> > 1.07_01.
>
> Must be 1.07_01 'cause I am running 1.07. I will download and try it.
> is the _01 designation ok for production use?
Better yet, can anyone point me to where 1.07_01 lives? It's not on CPAN.
>
> And by the way, I hopefully fixed the email chaining - someone grabbed
> the thread for a completely unrelated question.
>
> >
> > 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
>
> > [EMAIL PROTECTED] - 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'.
> > [EMAIL PROTECTED] (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
> >
>
--
Matthew O. Persico
