grafixgirl
asked on
ASP.net Ms. Access database connection?
Hello
I have switched hosting companies, and previously I had a folder "App_Data", where I had read and write permission. With the new company- they have given us read and write permission to another folder by the name access_db.
I know I need to make changes to the code below, but nothing seems to work
<asp:SqlDataSource ID="ctrlDataSource" runat="server"
ProviderName="System.Data. OleDb"
ConnectionString="Provider =Microsoft .Jet.OLEDB .4.0; Data Source=|DataDirectory|memb ers.mdb"
All help will be appreciated!
I have switched hosting companies, and previously I had a folder "App_Data", where I had read and write permission. With the new company- they have given us read and write permission to another folder by the name access_db.
I know I need to make changes to the code below, but nothing seems to work
<asp:SqlDataSource ID="ctrlDataSource" runat="server"
ProviderName="System.Data.
ConnectionString="Provider
All help will be appreciated!
ASKER
Connection strings works if I create a folder App_Data and store the .mdb file there. (I tested it)
so my problem is how to change the following code:
ConnectionString="Provider =Microsoft .Jet.OLEDB .4.0; Data Source=|DataDirectory|memb ers.mdb"
so it looks in to access_db instead of App_Data folder
so my problem is how to change the following code:
ConnectionString="Provider
so it looks in to access_db instead of App_Data folder
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
also have a look at:
http://www.connectionstrings.com/?carrier=access
towards the bottom are some samples