Update Recordset Errors

[pengprog]

After some problems here and there, I feel as if I have reached a wall with this error I have been getting when trying to do a RecordSet.Update

Microsoft Cursor Engine error '80004005'
Insufficient base table information for updating or refreshing.

The error is in the line that I call my update and after doing some searching on the internet it seems this is a bug or some sort...I am hosting my ASP, VBScript Files on an NT Server and querying Dbase 5 tables.

 

[palbano]

What is the query that builds the recordset?

-pete

 

[pengprog]

Here is a bit of the code. It works fine when running in WinXP...

Set RS = Server.CreateObject("ADODB.Recordset&quot
sql = "SELECT * FROM BEMIMA.DBF WHERE UNAME = '" & Session("USERNAME&quot & "' AND PW = '" & Session("PASSWORD&quot & "'"
RS.CursorLocation = adUseClient
RS.Open sql, objConn,adOpenStatic,adLockOptimistic

If not RS.EOF then
'update the record

RS("PW&quot = new_pass
RS.Update
Session("password&quot = new_pass

 

[palbano]

>> RS.CursorLocation = adUseClient
>> RS.Open sql, objConn,adOpenStatic,adLockOptimistic

Not sure about your use of adUseClient and adOpenStatic. Did you check the ADO FAQ's for this forum?

-pete

 

[Tarwn]

Is Bemima the database name? If so, then the problem may be that your connection is not resolving to the defaul database. You should specify this database name in your connection string so that you can simply reference tables inside it without having to reference the database name. ie:
Select * from dbf where uname=.....

-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
This space has nothing in it, it's all ni your imagination

 

[Tarwn]

I just read your other post so I might know what the problem is now, leave off the .dbf extension and make sure bemima is a table not the name of the database. Whn you put it in a name in dot notation like that it assumes that there is an object (either db or table or query) named bemima with a child table/query/etc named dbf

-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
This space has nothing in it, it's all ni your imagination

 

[pengprog]

Bemima is the name of Dbase table. When I connected to my databse I created a connection object that points to the directory where my tables are located, that name being "objConn". So in regards to your idea with taking the "." off, it seems to still react erroneously in the same way *sigh*. Any other suggestions. I did find something about trying to upgrade to MDAC 2.7. But after doing that I still get the same error.