Re: Advantages using 2005 JDBC Driver

Rick Brandt wrote:
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.

Replying somewhat to myself...I tried the beta version of the 2005 JDBC
driver and it appears to solve my problem.

Is using the Beta a scary proposition or is it fairly stable at this point?

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


.

Loading