Am I on the right track with taking data from one db and putting it into another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 31 Aug 2005 14:32 GMT

Here is my synatx with the error:

Error Type:
Microsoft JET Database Engine (0x80004005)
Could not find file 'C:\WINNT\system32\NTS.mdb'.
/FPSite/service/LMS/NTS/TestUPload.asp, line 18

<%

set ConnStr1 = Server.CreateObject("ADODB.Connection")
RelativePath = "../fpdb/NTS.mdb"
AbsolutePath = Server.Mappath(RelativePath)
ConnStr1.Provider = "Microsoft.Jet.OLEDB.4.0"
connStr1.Open = "Data Source="&AbsolutePath&""

set rs = Server.CreateObject("ADODB.Recordset")
RelativePath = "../fpdb/LMS.mdb"
AbsolutePath = Server.Mappath(RelativePath)
ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&AbsolutePath&""
mysql = "SELECT * INTO TBackup IN 'NTS.mdb' FROM ResultsCrit" ---- Line
18
rs.open mysql, ConnStr

%>

Reply to this Message

MGFoster - 31 Aug 2005 21:19 GMT

> Here is my synatx with the error:
>
[quoted text clipped - 20 lines]
>
> %>

Obviously, the relative path is incorrect. Use the complete path to the
.mdb file.

Explanation: This "../fpdb/LMS.mdb" means use the parent directory of
the current working directory. The error shows that the current
directory is C:\WinNT\system32. You need to either change the current
directory (I can't imagine how from an ASP page), or give the complete
path to the db.

Signature

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Reply to this Message