Connection Timeout failing. Why??

[Tim Field]

Just a standard connection from C# here, this works with a small amount of data but not a large set. Do I have the syntax wrong??

 

Thanks, Tim

 

SqlConnection mySqlConnection = new SqlConnection();

 

string strConn = "";

 

strConn = "Data Source=" + this.textBoxInstance.Text + ";" ;

strConn += "DataBase= " + this.textBoxDBName.Text + ";" ;

//strConn += " Integrated Security=SSPI ;" ;

strConn += "User ID = sa;" ;

strConn += " connection timeout = 10000000;" ; //connection timeout

 

mySqlConnection.ConnectionString = strConn;

SqlCommand cmd = mySqlConnection.CreateCommand();

[code Mechanic]

Hi

 

Try setting the Timeout property to zero, as far as I know this will force ADO to wait indefinitely until the connection is opened.

 

Cheers

 

CM :rolleyes: