Question about ASP command...

[Lmworld]

Hi all! I have a question about the ASP. I use this folowwing command in order to store my data in a access database but it cannot works, do you guys think is the server problem? But it works properly on my W2K system through the 'IIS' (Internet Information Services).

This is the ASP command that i mentioned above :-

cnnDB = Server.CreateObject("ADODB.Connection");
ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
Server.MapPath("Epalace2u.mdb");


Please guide, thanks in advance!!

LM

[dj4uk]

Right so it works on your own system - where doesn't it work?
Is where it is failing using IIS? using M$ Access?

[Lmworld]

Hi! It's works well in IIS, but doesn't works after i upload it to the server. Is it i should change the 'provider' in the coding side? Please guide, thanks!

LM

[mosquito]

Apparently the mdb file is stored in a folder part of the path, on your server the path of your database is not part of the path, so it can't find the database file.