FreeTDS Development Group

[Зверев Виталий Борисович <VZverev AT genesis.spb.ru>]

Hi Chad.
The 'nested statement handles' does not FreeTDS subject. 
Perhaps it will be closer to prepared statement model implementation for
Sybase & M$Sql.
Look at this...
http://www.geocrawler.com/archives/3/183/2000/12/0/4887830/
http://www.mbay.net/~mpeppler/DBD_SYBASE-0.93.pdf

Vitaly

-----Original Message-----
From: Chad Wagner [mailto:vdr781 AT yahoo.com] 
Sent: Thursday, March 20, 2003 6:26 AM
To: FreeTDS Development Group
Subject: RE: [freetds] How well does FreeTDS scale?



--- ZIGLIO Frediano
<Frediano.Ziglio AT vodafoneomnitel.it> wrote:
> Currently FreeTDS make a connection for every
> connection. 
> Connection pooler do not work very well...
> So all depend on mssql2k.


Since this topic has come up, it doesn't appear that
FreeTDS supports nested statement handles.  Anyone
know if that is in the roadmap, or am I just doing
something wrong?

I know this can be done with DBD::Oracle, and in
general with PL/SQL in Oracle (nested cursors).



(DBD::Sybase -- When autocommit is off)
1. Panic: Can't have multiple statement handles on a
single database handle when AutoCommit is OFF


(DBD::Sybase -- When autocommit is on)
2. DBI::db=HASH(0x81b5d44)->disconnect invalidates 1
active statement handle (either destroy statement
handles or call finish on them before disconnecting)

(DBD::ODBC)
3. DBD::ODBC::st execute failed: (DBD:
st_execute/SQLExecute err=-1) at ./test2.pl line 25.



Thanks,

Chad

__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds