Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recordset problem: "Rowset cannot be bookmarked"

Status
Not open for further replies.

antzzz

Programmer
Mar 9, 2001
85
0
0
AE
Hi, I created one table in SQL SERVER 7.0 and tried to connect to it using a recordset. First, I'm given an error message saying "Rowset cannot be bookmarked", then when I added a primary key to the table, it worked once! But then, when I tried to connect to the table again, I'm getting the same error again. When display the recordcount, it says -1. I have about 10 rows in the table and I can select them using Query Analyzer. I don't know what seems to be wrong. I have been creating Recordsets for a couple of years now, what seems to be wrong with this one???? Please help? I'm using sysadmin permissions with my application.
 
I need to see some of the code. Like the query statement.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top