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.
Thanks, Graham
