Hi,
(Im not entirely sure this is the right thread)
Im trying to connect to SQLExpress using a mobile web form.

here is the problem code
****************************************
   string strConn = (@"Data Source=.\\SQLEXPRESS;Database=members;Integrated Security=True;Connect Timeout=30;User Instance=True");

    //Create the SQL Statement
    string strSQL = "select * from members";

    //Create a Connection object
        SqlConnection conn= new SqlConnection(strConn);
        conn.Open();
********************************************

When I run the application I get a debugging error about the conn.Open();.

It says that there is an instance failure.

Ive looked around a fair bit but I cannot find a solution. Has anybody come across this or suggest how to resolve it?

Thanks

dub

You need to remove the second back slash in the data source name.
string strConn = (@"Data Source=.\SQLEXPRESS;Database=members;Integrated Security=True;Connect Timeout=30;User Instance=True");

Adam Gossage
Lake Wylie, SC, USA