Daniel;


My server doesnt' use trusted connection, anyway my problem is that SocketException is not being caught by the try/catch block, it breaks my program. I intentionally specified an ip address that doesn't have a sql server running.

Mario Chavez

From: "Daniel Morgan" <[EMAIL PROTECTED]>
To: "Mario Alberto Chavez" <[EMAIL PROTECTED]>
Subject: RE: [Mono-list] SocketException: Connection refused not caught by try/catch
Date: Wed, 15 Oct 2003 20:53:46 -0400


Just curious, is your SQL Server setup for authentication by SQL Server?
If it is Windows only, then yes, you would get the connection refused?

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Mario Alberto
Chavez
Sent: Wednesday, October 15, 2003 7:33 PM
To: [EMAIL PROTECTED]
Subject: [Mono-list] SocketException: Connection refused not caught by
try/catch



I've updated mcs and mono from last night (Otc-14) cvs, and now
System.Net.Sockets.SocketException is not being caught by try/catch. Please
see test case:
using System;
using System.Data;
using System.Data.SqlClient;

public class Test
{
    public static void Main(string[] args)
    {
        // Use a dummy server IP address
       string connectionString =
          "Server=10.128.9.10;" +
          "Database=pubs;" +
          "User ID=myuserid;" +
          "Password=mypassword;";
        try{
                IDbConnection dbcon;
                dbcon = new SqlConnection(connectionString);

                Console.WriteLine("Openning connection...");
                dbcon.Open();
                dbcon.Close();
                dbcon = null;
                Console.WriteLine("Closing connection...");
        }catch(Exception e){
                Console.WriteLine("Opps, no server");
        }
    }
}

mcs connection.cs -r System.Data.dll
mono connection.exe
Openning connection...

Unhandled Exception: System.Net.Sockets.SocketException: Connection refused

Regards,

Mario A Chavez Cardenas

_________________________________________________________________
Charla con tus amigos en l�nea mediante MSN Messenger:
http://messenger.yupimsn.com/

_______________________________________________
Mono-list maillist  -  [EMAIL PROTECTED]
http://lists.ximian.com/mailman/listinfo/mono-list


_________________________________________________________________
Charla con tus amigos en l�nea mediante MSN Messenger: http://messenger.yupimsn.com/


_______________________________________________
Mono-list maillist  -  [EMAIL PROTECTED]
http://lists.ximian.com/mailman/listinfo/mono-list

Reply via email to