Configuring Connection Strings

Ian Ryder · May 23rd, 2012, 05:44 AM

Hi All,

I am a bit lost on this one. My web host is 123-reg and I have created a database on their host to store the data as per the Beginning ASP.NET Book by Imar. The connection strings currently configured in the web.config file are as follows:-

Code:

<connectionStrings>
    <add name="PlanetWroxConnectionString1" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\PlanetWrox.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
    <add name="PlanetWroxEntities" connectionString="metadata=res://*/App_Code.PlanetWrox.csdl|res://*/App_Code.PlanetWrox.ssdl|res://*/App_Code.PlanetWrox.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=.\SQLEXPRESS;attachdbfilename=|DataDirectory|\PlanetWrox.mdf;integrated security=True;user instance=True;multipleactiveresultsets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>

Nothing new there really, but below is the connection information I have been provided by 123-reg for connecting to there web database. There are 3 options which are:-

Connection string (ASP.net)

Code:

<appSettings>
<add key="ConnectionString" value="Server=ATLAS-SQL-07; Database=bionatureagricultur_XXXXXX_db1; User Id=ubio_XXXXXX_0001; Password=XXXXXXXX" />
</appSettings>

Connection string (classic ASP: OLE)

Code:

myConnectionString="Provider=sqloledb;DataSource=ATLAS-SQL-07; Initial Catalog=bionatureagricultur_XXXXXX_db1; User Id=ubio_XXXXXX_0001; Password=XXXXXXXX;"

Connection string (classic ASP: ADO)

Code:

myConnectionString="Driver={SQL Server};Server=ATLAS-SQL-07;Database=bionatureagricultur_XXXXXX_db1;User Id=ubio_XXXXXX_0001;Password=XXXXXXXX;"

With still being new to ASP and only really knowing what Imar has taught me so far I have no idea where to start in modifying the original connection strings to accommodate the information from 123-reg.

Can anyone therefore give me any advice as to where to begin?

Thanks in advance for any help.

Kind regards,

Ian Ryder.

Imar · May 23rd, 2012, 12:05 PM

HI there,

Take the connection string from the example that uses appSettings (e.g. take the value) and put that in the connectionString attribute of your connectionStrings section in web.config.

No idea why they are suggesting to use appSettings instead of connectionStrings which is designed exactly for that purpose.

Cheers,

Imar

Ian Ryder · May 24th, 2012, 01:07 AM

Hi Imar,

Thanks for your comments and guidence once more. I have tried your solution in my connection strings and as I expected with 123-reg (not trying to belittle them) but I got nowhere. What I mean is there is no communication between the site and the databases and more frustratingly no error messages to try and pinpoint what's wrong.

I dont think there is much more you can help me with on this one so I have posted the issue with 123-reg to see is they can see why I am not communicating with their databases. I will let you know how I get on when they come back to me.

Cheers

Ian