-
JDBC: Connection is busy with results from another hstmt
I am using the MS ODBC DRiver 3.70.0517 with Sql Server 7 Beta 3.
Apparently I cannot have more than one STatement open for any given Connection.
I understand this problem occurs with ODBC with SQL Server and that there are work arounds at the ODBC level. The problem is due to cursors. However, I cannot use the usual solutions for ODBC since I am connected via JDBC. Does anybody have any idea how to get around this problem using JDBC-ODBC?
I would rather not use a different connection for each Statement.
Thanks in advance.
Steve "Crash" Agneta
p.s. Apparently many people are hitting this problem.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|