Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re: DBD::Sybase and Repserver

by mpeppler (Vicar)
on Jan 19, 2005 at 17:02 UTC ( [id://423437]=note: print w/replies, xml ) Need Help??


in reply to DBD::Sybase and Repserver

Could you try that with DBI->trace(4)?

I've used DBD::Sybase with rep server with no problems...

Michael

Replies are listed 'Best First'.
Re^2: DBD::Sybase and Repserver
by Anonymous Monk on Jan 20, 2005 at 08:57 UTC
    Are you saying that the example I gave should work ?
    When running with DBI_TRACE=4 I get this
    -> connect for DBD::Sybase::dr (DBI::dr=HASH(0x1ba63c)~0x10d178 'serve +r=MY_REPSERVER' 'repserv_user' **** HASH(0x24294)) New DBI::db (for DBD::Sybase::db, parent=DBI::dr=HASH(0x10d178), i +d=) dbih_setup_handle(DBI::db=HASH(0x10d13c)=>DBI::db=HASH(0x242948), +DBD::Sybase::db, 1b8f74, Null!) dbih_make_com(DBI::dr=HASH(0x10d178), 2410f8, DBD::Sybase::db, 242 +8, 0) thr#0 syb_db_login() -> checking for chained transactions servermsg_cb -> number=17001 severity=10 state=0 line=0 server=SRS +_SUNTS_TST text=No SRV_OPTION handler installed. clientmsg_cb -> ct_options(): user api layer: external error: An e +rror was returned from the server while setting theoptions, check the + server message for details. syb_db_login() -> chained transactions are not supported !! ERROR: 183 CLEARED by call to prepare method -> prepare for DBD::Sybase::db (DBI::db=HASH(0x10d13c)~0x242948 's +elect @@version') New DBI::st (for DBD::Sybase::st, parent=DBI::db=HASH(0x242948), i +d=) dbih_setup_handle(DBI::st=HASH(0x242a14)=>DBI::st=HASH(0x242a08), +DBD::Sybase::st, 242a20, Null!) dbih_make_com(DBI::db=HASH(0x242948), 243808, DBD::Sybase::st, 396 +, 0) thr#0 <- prepare= DBI::st=HASH(0x242a14) at Sybase.pm line 103 via repse +rv.pl line 11 -> execute for DBD::Sybase::st (DBI::st=HASH(0x242a14)~0x242a08) syb_alloc_cmd() -> CS_COMMAND 260608 for CS_CONNECTION 242c08 syb_db_opentran() -> ct_command( BEGIN TRAN DBI243808 ) = 1 syb_db_opentran() -> ct_send() = 1 servermsg_cb -> number=14024 severity=12 state=0 line=0 server=SRS +_SUNTS_TST text=Executor does not allow the entered command in the cu +rrent mode.
    Am I missing something basic ?
    I've done this with sybperl (albeit a few years ago) but cannot seem to get this example to work.
    Any help appreciated
      I figured it out. I hadn't setup an error handler in my example. A basic mistake !
      Thanks - that's exactly what I wanted. I see what the problem is - the code attempts (unnecessarily) to start a transaction, which is of course not supported when you connect to replication server.

      BTW - is this DBD::Sybase 1.05?

      Michael

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://423437]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others perusing the Monastery: (3)
As of 2024-04-20 00:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found