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="|DataDirectory|JsskDb.mdf";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="|DataDirectory|JsskDb.mdf";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: