Database Location Problem

[OrWolf]

I put my database in the fpdb folder as I thought I should. However, my system continues to look for database on the c drive in the winnt folder. See code and error lines below. Any ideas on what the problem is?

Connection Code:
Set objConnection = Server.CreateObject("ADODB.Connection&quot
objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=../fpdb/EDF.mdb;Persist Security Info=False"

Error:
Microsoft JET Database Engine error '80004005'

'C:\WINNT\fpdb\EDF.mdb' 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.

 

[link9]

Where is the script located??? It has to be in the c:\WINNT folder, or else it wouldn't be looking there for the .mdb --

Either give it an absolute path (i.e. c:\fpdb...etc...) or else make a DSN for it, and just use that to connect.


Paul Prewett

 

[bobmm]

Try using Server.MapPath("PathName&quot