Re: Advantages using 2005 JDBC Driver

Evan T. Basalik (MSFT) wrote:
That bug is addressed in the hotfix from KB917054. If you are still
facing the issue, feel free to open up a hotfix case with us and we
can deliver the hotfix for the CallableStatement issue.

That article only specifically talks about doing batch inserts, I get the
error below simply by calling a Stored Procedure that has multiple SELECT
statements in it. Does the hot-fix still apply?

com.microsoft.sqlserver.jdbc.SQLServerException: A server cursor is not
allowed on a remote stored procedure or stored procedure with more than one
SELECT statement. Use a default result set or client cursor.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Loading