Anyway, I guess I'm saying I've tried what you suggest but receive the same error. Invisible Bunny King Now is the only thing that's real.
Executewith rs m Command And it seems to work fine. Michael Lee I have a few observations of a general nature that might be helpful.
In my following code following error is displayed at line 4, whenever I execute the query str SQL. Anonymous If you create a recordset using connection.execute or command.execute, you will get a forward-only, read-only recordset.
No offense to them, but their customer service sucks. How are you locking the recordset, ad Lock Optimistic? I have tried turning it into an INSERT INTO statement, but I can't even get past the first line.
I have it set to RW (read/write) but I still get the error. So, in your opinion this means that it would be folder permissions.
If I check the Lock Type right after executing a addnew to the recordset the property changes to ad Lock Read Only. There is one other thing that I thought it could be. Here is an example of the code thats loading the recordset: If rs Insurance.
I have one field in the table set to uniqueidentifier and I have newid() in the Default value field in Enterprise manager. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. I know this because I receive the following error message: ADODB. In one of the tutorials I read, this was the recommended option. Here is the code involving this issue: Dim obj Conn Dim db Path Dim str SQL Dim table Name Dim rscustomers db Path="/db/Hockeycards.mdb" s Connection = "Driver=; DBQ=/db/Hockey Cards.mdb" Set obj Conn = Server. Connection") obj =3 '3="ad Mode Read Write Set rscustomers = Server. Recordset") table Name="Customer List" str SQL="SELECT * FROM Customer List" rscustomers. There is a chance I am wrong, but 99.9 percent of the time, this is a folder permissions issue, not a code issue. I assume you are able to read, you just can't update. You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. It worked great on my testing server, then conked out when it got on my real server. It may be working now, but I know the database it is trying to access is "locked". NET CDA/Wiley T...470131470.htmldparsons, Why yes, I am using ad Lock Optimistic. I have a website with some asp pages running off of a MS Sql db.For reasons that I can't explain, whenever querying the database with a SELECT query containing an order by clause, the returned recordset is read-only, regardless of cursor or lock type.The SQL server is running Windows 2000 Server and SQL 2000 The www ...