Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re^2: DBD::Sybase and Repserver

by Anonymous Monk
on Jan 20, 2005 at 08:57 UTC ( #423626=note: print w/replies, xml ) Need Help??


in reply to Re: DBD::Sybase and Repserver
in thread DBD::Sybase and Repserver

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

Replies are listed 'Best First'.
Re^3: DBD::Sybase and Repserver
by Anonymous Monk on Jan 20, 2005 at 09:49 UTC
    I figured it out. I hadn't setup an error handler in my example. A basic mistake !
Re^3: DBD::Sybase and Repserver
by mpeppler (Vicar) on Jan 20, 2005 at 18:36 UTC
    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
Node Status?
node history
Node Type: note [id://423626]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (9)
As of 2020-11-26 09:58 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?