October 10, 2001 at 12:20 pm
When I use OLE DB to connect to the SQL Server DB , using openkeyset cursor I open a RecordSet. If there are records the RecordCount Function returns the right count. If there are no rows it returns -1 instead of 0. Why ?
When I used ODBC before it returned 0. Is there any special connection setting I need to do ?
October 10, 2001 at 2:48 pm
what application are you connecting through?
October 11, 2001 at 1:11 pm
Visual Basic, and connecting throught ADO
October 11, 2001 at 2:45 pm
what type of cursor are you using to open the recordset. ReadOnly, ForwardOnly?
When using the above cursor type, it usually returns -1. If you were to use for example: static, optimistic cursor does it return 0?
October 11, 2001 at 5:48 pm
Cursor is OpenKeyset
October 12, 2001 at 3:10 pm
try using a different cursor type and see what happens?
January 22, 2002 at 12:23 am
Hi,
When I am using Open recordset statement with VB and ADO like following:
rsRecords.Open "select * from " & table_name, con, adOpenStatic, adLockOptimistic, adCmdText
I am getting an error message :
[Microsoft][ODBC SQL Server Driver][SQL Server]Cursor open failed because the size of the keyset row exceeded maximum allowed
Why its happening?????????
Thanx in advance
January 22, 2002 at 7:06 pm
Not sure...let me get back with an answer
January 24, 2002 at 7:00 pm
A few questions for you...
Are you using a client or server side cursor? Does the table contain a text datatype column?
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply