> On 7 Apr 2004, at 12:55, 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) > > I tried the odbc_cursortype solution in the POD docs, and it > unfortunately didn't help. I looked a bit for the thread that you > mentioned, but not too hard. I managed to get it working by > opening two > connections to the DB; not aesthetically pleasing, but it works.
If it didn't help, can you post/send a small example showing where it didn't help? I'd like to know, so that I can adjust the docs to fit the situation. Version of server, etc, are important. Did the test t/20SqlServer.t pass on your system? Thanks, Jeff
