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 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy