SQL connection test

Sample files written in ASP Net 2.0 to test connection to SQL server

Please download the following file: SQL_test.zip

Unzip into the root (WWW) of your website. Edit the file "web.config" and change the the "connection settings", replacing the defaults with your specific SQL database connection string:

<connectionStrings>
      <add name="MyDbConn"
         connectionString="Server=(local); Database=DBname; User Id=DBuserName; password=DBuserPassword"
         providerName="System.Data.SqlClient" />
  </connectionStrings>

Save the file and test at your website: http://www.yourdomainname.com/SQL_test