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.