On Wed, Apr 07, 2004 at 01:55:29PM -0400, Jeff Urlwin wrote: > > > > Hi. > > > > Is it possible to have two queries open at the same time on one > > connection to a DB? I'm using DBD::ODBC to access an SQL > > Server DB, if > > that makes any difference. > > > > I'm trying to access some info from one set, then, based on the the > > info from each result to that query, I need to get some info from > > another query. This works for about 63 queries, then I get an error > > message that says: "DBD::ODBC::st fetchrow_hashref failed: > > [OpenLink][ODBC][Driver]Function sequence error (SQL-HY010)(DBD: > > st_fetch/SQLFetch err=-1)" > > > > If I remove the accesses to the data from the second query, I > > get this > > error message: "DBD::ODBC::st fetchrow_hashref failed: > > [OpenLink][ODBC][Driver]Connection is busy with results for another > > hstmt. (SQL-IM921)(DBD: st_fetch/SQLFetch err=-1)" > > First, I encourage you to examine the DBD::ODBC POD documentation, and > DBD::ODBC::Changes POD docs to notice that DBD::ODBC 1.08 and above allow > setting of odbc_cursortype. t/20SqlServer.t has a test which shows how you > can use this odbc_cursortype. > > If that doesn't work for you, then I would google through this group and a > few (maybe more) months ago there was a LONG thread about it with options on > how to handle this (including some safe and not so safe options)
Actually I'd be grateful if someone could find and email me the google groups url for that that thread. Thanks. Tim.
