Unable to open database in ASP

[scislaghi]

Hello all,

from 4 days i've upgraded to 7.6.1 version from 7.5.6.

Now I get always problem to open db with asp pages. This is the error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

/common/include/tools.asp, line 19


Line 19 is:

Sub OpenDB (ByRef con, strDBName, strDBPath)
strPhysicalPath = Request.ServerVariables(4)

If Right(LCase(strDBName), 4) <> ".mdb" Then
strDBName = strDBName & ".mdb"
End If
' response.write strPhysicalPath & strDBName
' response.end
Set con = Server.CreateObject("ADODB.Connection")
' response.write "DRIVER=Microsoft Access Driver (*.mdb);UID=admin;UserCommitSync=Yes;Threads=3;SafeTransactions=0;PageTimeout=5;MaxScanRows=8;MaxBufferSize=2048;FIL=MS Access;DriverId=25;DefaultDir=" & strPhysicalPath & ";DBQ=" & strPhysicalPath & strDBName
con.Open "DRIVER=Microsoft Access Driver (*.mdb);UID=admin;UserCommitSync=Yes;Threads=3;SafeTransactions=0;PageTimeout=5;MaxScanRows=8;MaxBufferSize=2048;FIL=MS Access;DriverId=25;DefaultDir=" & strPhysicalPath & ";DBQ=" & strPhysicalPath & strDBName
End Sub



This is due a plesk upgrade?

Thanks
Stefano

__________________
Plesk 8 Debian 3.1
Plesk 7.6.1 W2K3
Dr.Web antivirus running

Visit: http://www.stefanocislaghi.it/

 

[JTRipper]

Check if IIS User has the proper permissions to write this file (via File Manager).
I've upgraded too and some of the permissions on my .mdb files were gone after upgrade.

 

[budwaiser]

I have the same problem after upgrade to 7.6.1.

Any ideas? Permissions seem correctly on folders and databases.

Thank you

 

[inCharge.co.uk]

This .asp script works on Plesk 7.5.1...

Dim objConnection
Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/test.mdb")

...Where test.mdb is in the root folder and it has all the permissions it could need.
But on Plesk 7.6 it generates this error...

Microsoft JET Database Engine error '80004005'
Unspecified error

...until the psacln account is granted read/write permissions to this folder:

C:\Documents and Settings\NetworkService\Local Settings\Temp

...which is used for Jet's temporary files.

To see the 'NetworkService' folder you'll need to uncheck 'Hide protected operating system files'
in Windows Exlorer/Tools/Folder Options/View

 

[somnath]

I have the same error in 8.2 and I did what you said but it didnt work!

Any ideas anyone on this error on 8.2?

 

[DmitryT]

Please try to check the internet sources:

http://support.microsoft.com/kb/234205/en-us
http://tutorials.aspfaq.com/8000xxxxx-errors/80004005-errors.html