Fwd: Can't connect to Sybase Rep server

---------- Forwarded message ----------
From: Matthew Persico <matthew.persico@xxxxxxxxx>
Date: Nov 20, 2006 12:45 PM
Subject: Re: Can't connect to Sybase Rep server
To: Michael Peppler <mpeppler@xxxxxxxxxxx>


Well, it's been more than a week. :-) No, I have not been on jury duty
THAT long, but now this is a production problem...

Well not really, I was able to fall back to using DBD::Sybase 1.00.

On DBD::Sybase 1.07 and your test 1.07_02 (from March 6), I get an
error connecting to a rep server.

Here is a test piece of code:
use DBD::Sybase;
$ldbh = DBI->connect("dbi:Sybase:"
. "server=REPP"
. ";hostname=" . 'nycux-25k102'
,'REPP_maint'
,'*******'
,{RaiseError=>1});
print $ldbh->errstr();
my $dummy = 6;

and results:

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'.

Any suggestions?


On 3/6/06, Matthew Persico <matthew.persico@xxxxxxxxx> wrote:
I'm on jury duty. It may take a week to get back to you.

On 3/6/06, Michael Peppler <mpeppler@xxxxxxxxxxx> wrote:
> On Thu, 2006-03-02 at 13:53 -0500, Matthew Persico wrote:
> > See the four attachments. RS is rep server version, the others should
> > be self explanitory. I included the .pl I used just for kicks.
> >
> > Thanks
>
> Hi Matthew,
>
> Could you try the attached and see if it improves things for you?
>
> Thanks,
>
> Michael
> --
> Michael Peppler - mpeppler@xxxxxxxxxxx - http://www.peppler.org/
> Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com/
> Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html
>
>
>
>


--
Matthew O. Persico



--
Matthew O. Persico


--
Matthew O. Persico
.

Relevant Pages

  • Get Segmentation Fault when Building Sybase
    ... When trying to install sybase 15 on fedora core 8 get the following ... Building Adaptive Server 'LOCALHOST': ... Specify a configuration file name in the RUNSERVER file to avoid this ... No external security mechanisms will be supported. ...
    (comp.databases.sybase)
  • Re: DBD::Sybase question
    ... You can interact with an ASE 15 server with a 12.5.1 client with no ... interface with all sorts of Sybase servers (including an antique 4.9.2 ... Toute utilisation de ce ...
    (perl.dbi.users)
  • RE: DBD-Sybase 1.07, FreeTDS 0.63, HPUX 11.11: Build problem (maketest)
    ... I guess I assumed that since TDS supports the host+port that the Sybase ... > does not appear that DBD::Sybase reconizes the freetds config file ... > arguments, and seems to want a "Server", only. ... Toute utilisation de ce ...
    (perl.dbi.users)
  • RE: DBD-Sybase 1.07, FreeTDS 0.63, HPUX 11.11: Build problem (maketest)
    ... > I guess I assumed that since TDS supports the host+port that the Sybase ... >> Sybase server and connect params. ... Toute utilisation de ce ...
    (perl.dbi.users)
  • Re: Sybase Client, issues with isql
    ... I am trying to establish a connection from windows with sybase server ... located on unix. ... I have created a Server Name Entry using DSEDIT. ...
    (comp.databases.sybase)