exec of stored procedure not working with Microsoft sqljdbc 2.0
Posted on 2009-07-14
I am running an SQL Server stored procedure from a jsp program. It has been running fine with Microsoft sqljdbc driver version 1.1, but today I installed version 2.0. Now when I run the SP I get:
DROPreport.jsp: 0, The statement did not return a result set.
exec dbo._DROPinterest_sp '546370',null
The last line above beginning "exec dbo. ..." is the query.