'80004005' General error Failed to get t

Results 1 to 3 of 3

Thread: '80004005' General error Failed to get t

  1. #1
    Join Date
    Dec 1969

    Default '80004005' General error Failed to get t

    Ive created an ASP page that displays data from an Access Database and provides the option to add or delete records. When I run it I seem to get the following error message:...<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80004005&#039; <BR><BR>[Microsoft][ODBC Microsoft Access 97 Driver]General error Failed to get the expression service <BR><BR>/steve/product.asp, line 9 <BR><BR>...the code fragment follows which it seems to be referring to. I have searched Microsofts knowledge base but it doesn&#039;t help with this particular message. Anybody have a suggestion that may help?<BR><BR><BR>7 &#060;%<BR>8 Set oConn = Server.CreateObject("ADODB.Connection")<BR>9 oConn.Open "steve"<BR>10 <BR>11 getSQL = "Select * From prodguide"<BR>12 Set oRs = oConn.Execute (getSQL)<BR>13<BR>14 %&#062;<BR><BR><BR>Thanks<BR>

  2. #2
    Join Date
    Dec 1969

    Default This is what MSDN suggests

    Accessing Remote Machines <BR>Common Symptoms <BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80004005&#039; when attempting to open an ADO connection. <BR>ASP code that worked fine when the database was located on the IIS Server no longer works when the SQL or Access database is moved to a remote machine. <BR>Description <BR>One of the most common types of problems occurs when ASP attempts to access resources located on remote machines. A good example of this is using ADO to access either SQL Server on a remote machine or an Access .mdb file located on another Windows NT machine. The problems stem from the fact that ASP is operating in the context of the IUSR_MACHINE account. On servers that are not primary or backup domain controllers, the IUSR_MACHINE account is a local account. Since this local account is not recognized on the remote machine, access is denied to the database. <BR><BR>Debugging Techniques <BR>The two most common workarounds for this problem are: <BR><BR>Change the Anonymous Logon account on the IIS server from IUSR_MACHINE to a domain account that is recognized by both machines and has sufficient permissions to the resource. In addition, be sure that this account has the log on locally user right on the IIS machine. Recall that the Anonymous Logon account is configured through Internet Service Manager. <BR>Note: If you later decide to change back to the IUSR_MACHINE account, be sure that the password provided in Internet Service Manager matches the password provided for this account in the User Manager tool. If the passwords do not match, you will encounter Access Denied errors. <BR><BR>Add a local account to the remote machine that exactly matches the username and password of the IUSR_MACHINE account on the IIS machine, and give this account access to the database. <BR>Note: This workaround is not recommended because it involves maintaining two separate accounts. If the passwords get "out of sync" at some point in the future, access will be denied to the database, and errors will occur. <BR><BR>

  3. #3
    Join Date
    Dec 1969

    Default RE: '80004005' General error Failed to g

    Check the last post of today.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts