Search results matching tag 'classic ASP access IIS7 on VISTA home premium'

Got problem with MS Access, please help.

Chonanis — Mon, 16 Mar 2009 09:43:53 GMT

I'm running IIS7 on Window Server 2008. There are about 100 domains in my server. Most domains work fine, but there usually has problem with domains which are using MS Access with asp. Those domains work fine for some time, then these error occur:

"Microsoft JET Database Engine error '80004005'" or "Active Server Pages error 'ASP 0113' Script timed out"

I used to try restarting IIS, it doesn't help. What I have to do is rebooting my server, then everything will get back to work as normal. This problem happen about once to twice times a week. While the problem happens, other domains which are not using MS Access work fine.

I don't think that it is because of the coding, because it happens to every domains which are using MS Access. What can be the cause? And how prevent it to happen again? Please suggest.

Another Classic ASP & IIS 7 Issue

olavarrieta — Mon, 15 Dec 2008 20:39:02 GMT

Hi,

Like most, I've been trying to set up classic asp and IIS7 on my Vista laptop for about 27 days now. I've done every tutorial step by step again and again but nothing works. including these steps:

%windir%\system32\inetsrv\appcmd set config /section:applicationPools /[name='DefaultAppPool'].processModel.loadUserProfile:false

icacls %windir%\serviceprofiles\networkservice\AppData\Local\Temp /grant Users:(CI)(S,WD,AD,X)

icacls %windir%\serviceprofiles\networkservice\AppData\Local\Temp /grant "CREATOR OWNER":(OI)(CI)(IO)(F)

I keep getting the:

Microsoft JET Database Engine error '80004005'
Unspecified error

Does anyone know what else I can do to get this going?

Re: #include directive in IIS7

Justin2020 — Thu, 02 Oct 2008 20:45:00 GMT

I discovered a solution. If I change the included filename's extension to anything other than 'inc' and 'asp', it works.

SessionMgr.Session

znwpta — Tue, 23 Sep 2008 15:53:19 GMT

Has anyone here been successful using this (http://msdn.microsoft.com/en-us/library/aa479313.aspx)

I donwload and installed , I believe the settings are proper, since the ASPX test page works. but the Classic ASP seems to be hanging when trying to create the object.

Anyone has any idea why?

Thanks

Access DB connection Error

ShotoCon — Tue, 17 Jun 2008 22:30:01 GMT

I developed a piece of software on my old machine using IIS on Server 2003 (Virtual PC Platform) and have moved it to my new machine to play with. Unfortunately, MSVPC not installable on Vista so using IIS 7. Although I am able to display ASP pages, I am not able to process any information from the access databaes Im using in the back end.

Original message being returned was along these lines:

Problem occured whilst processing URL. Please contact System administrator

Followed advice in other threads on this forum and turned off friendly error messages, this was then returned:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Disk or network error.

/quizCreate.asp, line 40

The code line it is refering to is of course the db connection opening, so here is the code and all lines before pertaining to it:

            accessDb = "eBug.mdb"

            myDSN = "DRIVER={Microsoft Access Driver (*.mdb)};"
            myDSN = myDSN & "DBQ=" & server.mappath(accessDb)

            Set dbConnection = Server.CreateObject("ADODB.Connection")
            dbConnection.Open myDSN - this is line 40

Figured that it was because I was using an Access 2003 database and only have Office (including Access) 2007 on this machine. (is this assumption correct???)

Downloaded & installed the Access Database Connection stuff from the microsoft website, saved the original db as an Access 2007 DB and changed the connection settings to this:

            accessDb = "eBug.acccdb"

            myDSN ="Provider = Microsoft.ACE.OLEDB.12.0;"
            myDSN = myDSN & "Data Source = " & Server.mappath(accessDb)

            Set dbConnection = Server.CreateObject("ADODB.Connection")
            dbConnection.Open myDSN

New error message now:

Microsoft Office Access Database Engine error '80004005'

Unspecified error

/destroyDB.asp, line 31

Dont worry that its in a different file, all my files were using the same connection settings to the same database, I am only using this one as an example as it is the one open at this time.

Every user on the machine has full control to this folder, have even run the grant user access command prompts posted in other threads.

Still have no idea why I cannot access information in the database. If you need any more information please let me know and ill happily post it, really hope someone can help me out with this.

BTW - was I correct in having to upgrade the DB to Access 2007 one, would be really really handy if i didnt have to and could still use 2003 (even if i dont have office 2003 installed) as a lot of my old projects that use access as their DB are configured to access a 2003 DB using the first method shown here.

Cheers

Vista, IIS7, MS Access 2007 DB, Error - Microsoft JET Database Engine error 080004005

bgoat1 — Thu, 01 May 2008 22:02:38 GMT

I've looked at all the posts I can find on this problem and tried all of the fixes but I'm still having a problem. The error I'm getting is:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0xd40 Thread 0x17e4 DBC 0xd19004 Jet'.

/orderforms/OrderFilters.asp, line 9

Here is my connection string

Dim MM_Filters_STRING
MM_Filters_STRING = "Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\inetpub\wwwroot\db\AirManageFilters.accdb"
%>

Since I'm using a MS Access 2007 database it looks like I need to use the ODBC driver. When I sent up the recordset I can run a test and get all the data. It just doesn't allow me to display the asp page.

I will be forever greatful for any and all help!

Bgoat1

classic ASP Access database IIS7 on VISTA home premium

cold_man_bk — Wed, 19 Dec 2007 03:01:47 GMT

Hi all. anybody help me. I am not familiar with IIS7 on VISTA, I only know on XP. I installed IIS7 already but when I browse the ASP page It said that : (An error occurred on the server when processing the URL. Please contact the system administrator) I dont know how to deal with that?

Thanks alot buddy.

regards.