| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
database/asp was perfect but suddenly stopped working |
|
From: |
jan |
|
Date: |
4/17/2001 7:47:58 AM |
|
IP: |
194.78.245.174 |
can anyone help me?
An asp is to change a database. until recently, everything worked fine for some time, but after a three months of non-usage, whenever the script updates the db, an error is generated. web admin says he hasnt changed configurations. Follows the code and below the generated error message:
' create database object
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};Dbq=" & myMDB
objConn.Open
Set Session("mdbDefined") = objConn
...
' record is to be updated:
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open sqlQuery, objConn, 1, 2
objRS("field1") = "juhuu"
objRS.Update
objRS.Close
Set objRS = Nothing
The "Update" method generates the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
It WORKED some time ago, and reading and displaying the databse still works. So what could that be? I know, it sounds as if the web admin had changed security settings, but he says he hasnt.
Thanks for any hints,
Jan |
Follow Up - Re: database/asp was perfect but suddenly stopped working - Chris WIlliams 4/17/2001 9:21:13 AM
|
|
|
|
|
|
