Unable to Connect to Database on IIS

• • Reply

  11 years ago

  by royal ludhiana

  Royal Ludhiana

  Toronto, Canada

  Joined 14 years ago

  Hi,

  I have hosted my web application(asp.net with C#) on IIS on my system. The database is in access. When I try to login, it doesn't connect to the database. My Connection String is in web.config and database is in App_Data.

  After googling, I got some solutions which suggested to change the connection string through code. The main idea is to get the physical path of the database. but still it doesn't work.

  Any suggestion?

  Regards,

  Royal

  Report abuse
• • Reply

  11 years ago

  by yf2009

  YF Wong

  Seri Kembangan, Malaysia

  Joined 11 years ago

  Hi, can you share with us on the error message that you get from accessing the database. Suggest to use Sever.MapPath that refer to database in AppData. Eg. Server.MapPath("../db.mdb"). And if this is not working, can you share with us the information of the path of your application and AppData?

  Report abuse