A New Internet Library: Add Your Website/Blog or Suggest A Website/Blog to our Free Web Directory http://anil.myfunda.net.

Its very simple, free and SEO Friendly.
Submit Now....

Thursday, July 24, 2008

Data Sting in Job Site

I posted this under the Job Site section as well but I have not had any answers as yet!

How do I change the database connection string to SQL Server 2005?

The current string in the config reads:

 <connectionStrings>
    <add name="connectionstring" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=&quot;|DataDirectory|JsskDb.mdf&quot;;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
    <add name="MyProviderConnectionString" connectionString="Data Source=.\SQLEXPRESS;Integrated Security=True;AttachDbFilename=|DataDirectory|JsskDb.mdf;User Instance=True" providerName="System.Data.SqlClient"/>
  </connectionStrings>

Can I change it to:

<connectionStrings>
    <add name="connectionstring" connectionString="Data Source=NATASJA;Initial Catalog=jobs;AttachDbFilename=&quot;|DataDirectory|JsskDb.mdf&quot;;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
    <add name="MyProviderConnectionString" connectionString="Data Source=NATASJA;Initial Catalog=jobs;Integrated Security=True;AttachDbFilename=|DataDirectory|JsskDb.mdf;User Instance=True" providerName="System.Data.SqlClient"/>
  </connectionStrings>

NATASJA being the name of my SQL server.

Thanks!



Source Click Here.

No comments:

Post a Comment

Post your comments here:

Originals Enjoy