another Access Connection Question

[mnye]

Using .Net framework 1.1 for a web app connecting via OLEDB. I put the .mdb in the "/bashmentmed/_database/" directory and then published my app via the Front Page Extentions from VS.Net 2003. My connection string is as follows:

Dim cnnStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("\_database\bjp.mdb") & ";User Id=admin;Password=;"

and I get the following error:

'c:\bashmentmed\_database\bjp.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.

What am I doing wrong? Thanks for the help.

Regards,
Matt

[joelt]

That sounds very strange. Your path should be 'e:\web\bashmentmed\htdocs\_database\bjp.mdb' right?

Are you using code behind? I've seen problems with codebehind not compiling properly. Try removing the dll and resyncing the project.

[mnye]

joelt,

yeah I am using code behind pages. Im not sure if my root should be e:/web/. Is that the default for discontasp.net? This is my first time using this hosting company. When I ftp my files up, it showing the directory "/bashmentmed/_database" but I dont see an "htdocs" directory.

thanks for the help.
Matt

[Eric]

You can always look in the Account Information section of your control panel to find the full path.

[iqnh]

Thank you all. I made my web app work and connect to the access db.