all groups > sql server msde > december 2005 >
You're in the

sql server msde

group:

Value of parameter 'nrows' is invalid


Value of parameter 'nrows' is invalid Josep Solà
12/19/2005 11:15:00 AM
sql server msde: Hi,

I'm using a Recordset with UseServer and Keyset cursor.

It works fine except when I ask about record count. Then my application
raises this message "sp_cursorfetch: Value of parameter 'nrows2 is invalid"

What can I do to solve this?

Re: Value of parameter 'nrows' is invalid Andrea Montanari
12/19/2005 11:58:15 AM
hi Josep,
[quoted text, click to view]

are you calling a stored procedure which include the use of a cursor?
try debugging it...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Re: Value of parameter 'nrows' is invalid Josep Solà
12/19/2005 12:14:58 PM
Hi Andrea,

Thanks for your answer.

I am not use any stored procedure. I only use a select statement, but with
that cursor type. Also, I configured cursor threshold to 0.

Any idea?

Thanks,

Josep


"Andrea Montanari" <andrea.sqlDMO@virgilio.it> escribió en el mensaje
news:40ni28F1b9l8hU1@individual.net...
[quoted text, click to view]

AddThis Social Bookmark Button