[RESOLVED] why this connection string doesnt work?

[bulbish]

delete

[HairyMonkeyMan]

Which version of access are you using?

You should have the local path to the mdb file. I've never seen one with http://.... etc

[bulbish]

what path should i use if my ASP VB program is in the http://weblab.devry.edu/LNGBIS355XSUM08A/PMcDonald/FountainOfYouthBookstore

folder and i copied the mdb database to the same folder for simplicity .

- by the way, is it ok to just copy the mdb file to a different folder?

[bulbish]

weblab.devry.edu/LNGBIS355XSUM08A/PMcDonald/FountainOfYouthBookstore

[eclipsed4utoo]

I am going to tell you the truth, I don't even know if you can access a database on the internet. I am 90% sure that the database needs to be on your PC. Though I could be wrong.

[bulbish]

yes, but the script runs on the same server , i run it from the server, not from my pc
go to and run it yourself and see what error you get

http://weblab.devry.edu/LNGBIS355XSUM08A/PMcDonald/FountainOfYouthBookstore/HomePage.aspx

[eclipsed4utoo]

Your connection string that you posted is not what is being used on the server. Post the code that the server is using to open the database.

[bulbish]

Your connection string that you posted is not what is being used on the server. Post the code that the server is using to open the database.

i thought the only infotrmation that was important was what folder the mdb database file was in.. i know there is no password or username

[HairyMonkeyMan]

yes, you are right... only the directory is important. And yes, scripts can access it from the same server. I doubt your website resides in the root directory of the c drive. If you're not sure, put this code in a page:

Dim path as string = Server.MapPath(".")
response.write(path)

HTH