9 replies to this topic

[rmfred]

Hello, this just started happening after having done some fixes as detailed in thread http://forums.whatth...howtopic=124590

Prior to running those fixes, all ASP pages and database connected ASP pages worked fine. I can still access ASP pages, but if an ASP page is connecting to an access database I get errors. Most common one is this:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

If I move the ASP files and database(s) to my laptop everything works fine. In addition, the pages work fine when on the web & hosted by my hosting company.

Since everything worked prior to running the fixes, everything works when put on another machine, and everything works when on the web; it is logical to assume "something" has changed on my machine as the result of running the suggested fixes from the above mentioned thread; but I am at a loss to determine just what has changed.

Comparing IIS settings from PC to laptop shows no differences, the IUSR account on both PC and laptop have the same security settings etc etc.

Would appreciate any ideas.

If this is posted in the wrong forum, my apologies, and if so, feel free to move to the proper forum.

Thanks

[Ztruker]

Have you seen this MS Article: PRB: Error 80004005 "The Microsoft Jet Database Engine cannot open the file '(unknown)'"

Lots of other hits with a Google search for: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'.

It sounds to me like a a permission problem caused, as you mentioned, by one of the tools used to check your system for malware. If nothing in the above links helps, give Windows Repair (All In One) from Tweaking.com. a try. - Note: Please use the latest available version.

Windows Repair is an all-in-one repair tool to help fix a large majority of known Windows problems including registry errors and file permissions as well as issues with Internet Explorer, Windows Update, Windows Firewall and more. Malware and installed programs can modify your default settings. With Tweaking.com - Windows Repair you can restore Windows original settings.

Download it ===> here.

Install and then run the program.

Click on each of the Step tabs and perform the indicated processes if you have not already done the same or similar things. It's important to do these steps so please take the time to do so.

Click on the Start Repairs tab.

Click Start. If you did not perform Step 4 to create a registry backup, you will be prompted to do so. I strongly urge you to do it.

Click the Unselect All button then select just the items shown in the following image unless directed to do otherwise.

DO NOT check the Restart/Shutdown System When Finished box as you will want to see anything that happens during and at the end of the repair process.

Click the Start button and let the process run to completion. Record error messages if there are any then reboot.

Note: The above is a canned speech I use so look at each of the sections I show to check. I think you only want to do a few of them, specifically

Reset Registry Permissions
Reset File Permissions
Remove Policies Set By Infection
Repair Proxy Settings
Set Windows Services to Default Startup

Make sure you do Steps 1 through 4 first before running any repairs.

[rmfred]

Thanks... I've gone through everything I can think of relating to ASP errors (including the links you posted) - permissions on the databases are fine as is everything else I've looked at. I'll try the Windows Repair tool and see what happens... maybe that will also fix the problem I have with FireFTP that started after doing the original malware fixes

[rmfred]

Windows Repair seems to have done the trick... the ASP files are working properly. BUT, after running all the steps in windows repair and restarting my machine; my anti-virus (Sophos) is reporting a virus/spyware (was not reporting it prior to running windows repair). It is reporting the following: CXmal/Badlnk-A and it is reporting the location as: \\.\GlobalRoot\Device\Harddisk\VolumeShadowCopy1\Documents and Settings\username\recent\windows repair.lnk \\.\GlobalRoot\Device\Harddisk\VolumeShadowCopy2\Documents and Settings\username\recent\windows repair.lnk Thanks

[Ztruker]

I'm guessing it doesn't like WR-AIO for some reason. You can ignore it or let it fix it.

[rmfred]

Uninstalling WR_AIO took care of the constant anti-virus warnings

[Ztruker]

Thanks for the info. I let Shane over at Tweaking.com know about this.

[rmfred]

This morning I got this adware or PUA warning from Sophos about something called psExec C:\System Volume Information\_restore{4617D869-6DFF-4342-BE3F-6D5D37A05BC1}\RP11\A0011920.exe C:\System Volume Information\_restore{4617D869-6DFF-4342-BE3F-6D5D37A05BC1}\RP11\A0011920.exe\FILE:0000 It that something left over from WR-AIO or something completely different?

[Ztruker]

Different as it's in the System Restore area. Go to the Spyware / Malware / Virus Removal forum, read the info there and follow the posted directions. Once you receive a clean bill of health, come back here if you have any additional questions or concerns or it turns out not to be a malware problem.

Please be patient as that is a very busy area. If you do not receive a response in 3 days, post a message here: What To Do If You Have No Response In 3 Days?

Do not reply to your post there as the malware folks look for posts with no replies first.

[Sunil Jumani]

The only thing which matters from IIS configuration is the identity of the application pool in which your project is running. You have a SQL syntax that works properly. Next, you need to check the connection between your ASP and the database. Comment out whatever SQL line you are currently using as your execute string. If you are using SQL 2005 Express editions, then you can go to http://msdn.microsof...s/sql/download/ and you can download the Management Studio Express which will allow you to manage SQL User accounts and establish their permissions within databases.
---

Signature hyper-link Edited by Doug