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)"
Any ideas what I'm doing wrong here? Can I do this?
TIA, Graham
