Hi englere.
I commented code-line dr.Close(); so after build of task I got error: Use of unassigned local variable 'dr'. Then task Test was executed the result looks like:
_________________________________________
Exception: Login failed for user 'ThePhileUser'.

Press Return ...
______________________________________________

Debug: I will wait other replays. Thanks a lot for your help.

You can get around the "dr" error by using this code:
old:
  SqlDataReader dr;
new:
  SqlDataReader dr = null;

And you should change your finally clause:

   if (dr != null)
     dr.Close();
   if (con.State == ConnectionState.Open)
     con.Close();

And change the line that shows the exception:

Console.WriteLine("Exception: " + ex.Message + " Exception type: " + ex.GetType().ToString());


But you weren't able to connect to your database, so you need to figure out the right connection string. Did you plug in your own info in the Connection String? You can visit ConnectionStrings.com to see if they can help you.

To make it easier for you, here's the whole program with the changes:

using System;
using System.Data;
using System.Data.SqlClient;

namespace ConnectTest
{
  class ConnectTestClass
  {
    static void Main(string[] args)
    {
      try
      {
        // Plug in your own connection string below:
        string conStr = @"server=(local);database=ThePhile;uid=ThePhileUse r;pwd=password;";
        SqlConnection con = new SqlConnection(conStr);
        con.Open();

        Console.WriteLine("Tables in the database:");

        // This SQL lists the tables in the DB
        String sqlStr = "select name from sysobjects where type='U'"
          + " and name not like 'dt%' order by name";

        SqlCommand cmd = new SqlCommand(sqlStr, con);
        SqlDataReader dr = null;
        try
        {
          dr = cmd.ExecuteReader();

          while (dr.Read())
          {
            Console.WriteLine("{0}", dr.GetString(0));
          }
        }
        finally
        {
          if (dr != null)
            dr.Close();
          if (con.State == ConnectionState.Open)
            con.Close();
        }
      }
      catch (Exception ex)
      {
         Console.WriteLine("Exception: " + ex.Message + " Exception type: " + ex.GetType().ToString());
      }
      Console.Write(Environment.NewLine + "Press Return ...");
      Console.ReadLine();
    }
  }
}

Hi englere
In your code I changed uid=ThePhileUser to uid=sa.
string conStr = @"server=(local);database=ThePhile;uid=sa;pwd=pass word;";
It is like I have in my config files. Is that correct?

I show all my ConnectionString config files of project ThePhile:

Web.config
<sessionState
   mode="InProc"
   stateConnectionString="tcpip=172.18.56.50"
   sqlConnectionString="data source=(local);uid=sa;password="
   cookieless="false"
   timeout="20"
/>

Accounts.config
<ConnectionString>server=(local);database=thePhile ;uid=sa;pwd=;</ConnectionString>

AdsManager.config
<ConnectionString>server=(local);database=ThePhile ;uid=sa;pwd=;</ConnectionString>

Forums.config
<ConnectionString>server=(local);database=ThePhile ;uid=sa;pwd=;</ConnectionString>

MailingLists.config
<ConnectionString>server=(local);database=ThePhile ;uid=sa;pwd=;</ConnectionString>

NewsManader.config
<ConnectionString>server=(local);database=ThePhile ;uid=sa;pwd=;</ConnectionString>

Then I rebuild and execute your code.

Result after execution:
__________________________________________________ _________________________
Exception: Login failed for user 'sa'. Exception type: System.Data.SqlClient.SqlException

Press Return ...
__________________________________________________ _________________________

Debug I will wait other replays. Thanks a lot for your help.

I don't know how to help you anymore. I don't know what your account info is, and this is clearly a connection problem. You should see if a friend can help because someone has to sit down at your computer and figure out how your Sql Server is set up. You should probably get a beginners book on Sql Server, also. This project assumes you know how to use it.

Eric

Hi englere.
After reinstallation ThePhile project I got new result. May be with that error will easy to fix the problem.

Thanks.