Access connection string help…

Access connection string help…

Using visual studios 2008 I created an Access connection string that looks like this:

<add name="csFlagFootball" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=App_Data\flagfootball.mdb;Persist Security Info=True" providerName="System.Data.OleDb"/>

When I deploy the site to discountasp.net hosting. The datasource is not recogized and don’t recive any of the data…

I have never worked with deploying an access DB to a site but thought this would work just fine for testing…


Any help with creating a valid connections string from the web config would be appreciated.


Thanks in advance
Gary

 

You need to store you Access DAta base in an especial folder called _database are you doing that? do you have this folder in the root menu? If not you will have to create it. This is the most simple solution in case this does not work we can keep trouble shooting.

 

So the new connection string should look like

<add name="csFlagFootball" connectionString="Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=_database\flagfootball.mdb;Persist Security Info=True" providerName="System.Data.OleDb"/>

 

...We're getting a lot of questions about this.
If you're using Visual Studio there are better ways to do this.
Are you? Want a Webcast showing how?
I'm not trying to be funny, just helpful. ;-)

 

Sounds great i would love a webcast to tell me how to do this better. Any help with my question would be welcomed..

 

...Roger that...I'll try and get it done this weekend, the DASP crew already gave me the go ahead. ;-)

 

...Sorry for the delay, I hope to have it on-line tomorrow.

 

...I'm uploading it right now.
In about an hour from now it will be on: http://www.dasptv.com/

Sorry for the delay but for some reason my copy of VS2010 is crashing a lot.