Hi,

I have the chapter 12 example with the movie database working fine on my local computer. But when I publish using Frontpage to my webserver (updating line 21 to refer to the web server rather than my local machine), I get a strange error:

Microsoft JET Database Engine error '80004005'
Not a valid file name.
/BegASPFiles/connect.asp, line 21

A simple error, you might think - I've just referred to connect.asp instead of Movie2000.mdb. But I haven't! Honestly! Look, here's the connection code pasted from the connect.asp file on the webserver:

objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
               "Data Source=http://mywebserver.com/BegASPFIles/Movie2000.mdb;" & _
               "Persist Security Info=False"

What am I doing wrong???

Any help much, much appreciated - this is driving me bonkers.

Cheers

Graham

Hi there,

The Data Source needs a physical path, not a Web path. So, you'll need something like this:

Data Source=C:\Database\BegASPFIles\Movie2000.mdb;


If you don't know where he physical file is located (when you host your site with an ISP for example), but you *do* know it's located in a folder called Databases in the root of your site for example, try this for the connection string:

objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("/Databases/Movie2000.mdb") & ";" & _
     "Persist Security Info=False"

This will return a path like c:\inetpub\wwwroot\YourSite\Databases\Movie2000.md b which is a valid path for the DataSource.

HtH,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thank you so much Imar!!!