System.Net.Sockets.SocketException

[designet]

Hi all,

i have a console app set up as a scheduled task which does a couple of different things

First it connects to the SQL Server and performs a simple query, then it launches a web page based on the query results. (the web page is ASP served from the same machine)

Both IIS and SQL Server are on the same machine that will have the scheduled task running.

I am developing the app on a separate machine, and when i run it it does everything correctly.....goes off to the server, connects to SQL , gets a results dataset back, then goes off to the web page and feeds it the data.

When i copy the app to the server though, i get :
Unhandled Exception: System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it


Any pointers on why i would be able to connect remotely, but not locally?

i am new to developing in .NET so i could well have forgotten to copy a file over, or maybe i need to configure something else....i dont know....HELP!
i have basically just copied the whole BIN/RELEASE directory over to the server machine....that should have everything it needs shouldn't it?

[designet]

code :

   class doMyCheck
    {
        static void Main()
        {
            string field1, field2, connstring = "", sql;
            SqlConnection c;
            SqlCommand sqlcommand;
            SqlDataAdapter sqldataadapter;
            DataSet dataset;
            DataTable datatable;
            int id;
 
            connstring += "data source=MYSERVER;";
            connstring += "user id=**********;";
            connstring += "password=************;";
            connstring += "initial catalog=**********************;";
 
            c = new SqlConnection();
            c.InfoMessage += new SqlInfoMessageEventHandler(OnInfoMessage);
            c.StateChange += new StateChangeEventHandler(OnStateChanged);
            c.ConnectionString = connstring;
            c.Open();
 
            if (c.State == ConnectionState.Open)
            {
                sql = "SELECT * from view**********************";
                sqlcommand = new SqlCommand();
                sqlcommand.Connection = c;
                sqlcommand.CommandText = sql;
                sqlcommand.CommandType = CommandType.Text;
                sqldataadapter = new SqlDataAdapter();
                sqldataadapter.SelectCommand = sqlcommand;
                dataset = new DataSet();
                sqldataadapter.Fill(dataset);
                datatable = dataset.Tables[0];
                string baseURL = "http://www.***********.com/myPage.asp";
                string postData;
                foreach (DataRow drow in datatable.Rows)
                {
                    id = (int)drow[0];
                    field1 = drow[1].ToString();
                    field2 = drow[2].ToString();
                    Print(id.ToString(), 6);
                    Print(field1, 20);
                    Print(field2.ToString(), 6);
                    postData = "id=" + id.ToString();
                    HttpWebRequest req = (HttpWebRequest)WebRequest.Create(baseURL);
                    req.Method = "POST";
                    ASCIIEncoding encoding = new ASCIIEncoding();
                    byte[] byte1 = encoding.GetBytes(postData);
                    req.ContentType="application/x-www-form-urlencoded";
                    req.ContentLength = postData.Length;
                    Stream newStream = req.GetRequestStream();
                    newStream.Write(byte1, 0, byte1.Length);
                    Console.WriteLine("The value of 'ContentLength' property after sending the data is {0}", req.ContentLength);
                    newStream.Close();
                }
                datatable = null;
                sqldataadapter = null;
                sqlcommand = null;
                c.Close();
            }
            c = null;
            Console.Read();
        }
        protected static void OnStateChanged(object sender, StateChangeEventArgs e)
        {
            Console.WriteLine(
                "sql server state is -> {0}",
                e.CurrentState.ToString("g")
            );
        }
        protected static void OnInfoMessage(object sender, SqlInfoMessageEventArgs e)
        {
            foreach (SqlError err in e.Errors)
            {
                Console.WriteLine(err.Message);
            }
        }
        static void Print(string towrite, int maxlen)
        {
            if (towrite.Length >= maxlen)
            {
                Console.Write(towrite.Substring(0, maxlen - 4) + "... ");
                return;
            }
            towrite += new string(' ', maxlen - towrite.Length);
 
            Console.Write(towrite);
        }
    }

[Plater]

So it's the SQL part that creates the socket exception and not the website one?

It would be a bit abnormal for this to happen, but is your SQL server setup to allow local connections (via "named pipes" probably)??
Only other thing I can think of is something to do with permisions for the credentials that your application is running on need to be set correctly.