Re: Problem with data access

From: Bob Barrows (reb01501_at_NOyahoo.SPAMcom)
Date: 04/18/04 

Date: Sun, 18 Apr 2004 15:27:24 -0400

S N wrote:
> i had a working site with iis5 winxp professional on a p4 machine.
> suddenly i am having problems with and the asp pages which have some
> updating commands for the database. the update commands dont work and
> i get one of the following error messages. i have tried restarting
> the computer and have also reinstalled microsoft office xp but the
> problem has not been solved as yet.
> please help
>
> 1. Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC Microsoft Access Driver]General error Unable to open
> registry key 'Temporary (volatile) Jet DSN for process 0x994 Thread
> 0xac4 DBC 0x147f024 Jet'.
>
>
> 2. Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
> object is read-only.

1. Stop using ODBC. The Microsoft OLE DB Provider for ODBC Drivers has been
deprecated and users are advised to use the native Jet OLEDB provider
instead. For a non-password-secured database, your connection string can be
as simple as :
conn.open "provider=micrososft.jet.oledb.4.0" & _
"data source=p:\ath\to\your\database.mdb"

You can use
"data source=" & Server.Mappath("database.mdb")
if your database is in a folder within the wwwroot folder.

2. These 80004005 issues are always NTFS permissions-related. The
IUSR_machinename account (and sometimes the IWAM_machinename account) needs
Change permissions for the folder containing the database file.

Bob Barrows

PS. Gack!! Why did you crosspost to so many groups??? This is an asp and
database issue. You did not have to post to so many groups.
microsoft.public.inetserver.asp.db is the perfect group for this question. 

-- 
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Relevant Pages

  • Re: Validate logins with ASP, MS Access and Cookies error
    ... If you plan to do much more ASP, I would advise looking for tutorials ... return another column from the database that stores the users 1st ... 'create connection and recordset objects ... Set cnStr = Server.CreateObject ...
    (microsoft.public.inetserver.asp.db)
  • Re: Validate logins with ASP, MS Access and Cookies error
    ... If you plan to do much more ASP, I would advise looking for tutorials ... return another column from the database that stores the users 1st name ... 'create connection and recordset objects ... Set cnStr = Server.CreateObject ...
    (microsoft.public.inetserver.asp.db)
  • Re: Linking Forms
    ... The second page code this must be an asp page ... This collects the information from the first form and stores it ... variables lines and then the fields of the sql insert to match your database ... To create the access database I often let frontpage do this for me by ...
    (microsoft.public.frontpage.client)
  • Re: Datasets - Best approach to use?
    ... William (Bill) Vaughn ... then you got the wrong books. ... Using ASP (or ... It accesses data in an SQL Server database. ...
    (microsoft.public.vb.database)
  • Re: newbie question on asp
    ... I am new to asp, and want to put a simple database on the web so the ... You and others can have access to a database hosted on the Web from any ... Dynamic Web pages are similar in many ways to regular HTML pages. ... Here are a few good ASP sites: ...
    (microsoft.public.inetserver.asp.db)