another Access Connection Question

Discussion in 'Databases' started by mnye, Oct 20, 2003.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. 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
     
  2. 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.
     
  3. 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
     
  4. Takeshi Eto

    Takeshi Eto DiscountASP.NET Staff

    You can always look in the Account Information section of your control panel to find the full path.
     
  5. Thank you all. I made my web app work and connect to the access db.
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page