Programming Journal C#, Java, SQL and to a lesser extent HTML, CSS, XML, and regex. I made this so other programmers could benefit from my experience.

Thursday, September 27, 2007

Connecting to Kensoft.net SQL Server 2005 database

The side note for this is that the database name in Kensoft has an '_' in it, not a '.'.


<connectionStrings>
<!--<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MyDatabase.mdf;Integrated Security=True; User Instance=True" providerName="System.Data.SqlClient"/>
-->
<add name="ConnectionString" connectionString="Data Source=mssql2005.kensoft.net;Database=myDatabase;uid=myUserId;pwd=myPassword" providerName="System.Data.SqlClient" />
</connectionStrings>

2 comments:

Anonymous said...

hey. Great Blog you've got here. I've been tooling around trying to find some new information and I think i found it! Thanks a lot!
I have a website too. You can check it out at Satellite TV for PC

Anonymous said...

Free Windows Password Reset Software - http://www.
windowspasswordrecovery.tk - For Windows8, Windows 7, Vista, XP, Windows 2000, Windows
Server 2003 and 2008 and NT passwords - Easy Free Password
Recovery Software - Crack Windows Passwords

What a information of un-ambiguity and preserveness of valuable familiarity regarding unpredicted emotions.