Hi there. I am working on a old system which uses Access 97 (I need to write a ASP.NET 2.0 front end for it). Does anyone know the correct connection string to go into my web.config file to get it to work with my DAAB?
I have tried a few Access connection strings on the net but none seem to work. I keep getting
"System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Configuration.ConfigurationErrorsException: The requested database mydbconnectionstring is not defined in configuration."
I have 2 databases I need to connect to and I have tried using OLEDB and ODBC but nothing seems to work.
Below is my Web.Config file if that helps (slightly edited).
<configuration>
<configSections>
<section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null"/>
</configSections>
<dataConfiguration defaultDatabase="Database1" />
<appSettings/>
<connectionStrings>
<add name="Database1" connectionString="myConnectionString.mdb" providerName="System.Data.OleDb" />
<add name="database2" connectionString="myConnectionString.mdb" providerName="System.Data.Odbc"/>
</connectionStrings>
..........
Anyone got any ideas?