Search results
default command timeout=0 in your connection string does the trick. String connectionString = "Server=myserver; Port=3306; Database=databasename; Uid=userid; Pwd=password;default command timeout=0";
The following code snippet sets a timeout of one minute: MySqlCommand cmd = new MySqlCommand(); cmd.CommandTimeout = 60; The default value is 30 seconds. Avoid a value of 0, which indicates an indefinite wait. To change the default command timeout, use the connection string option Default Command Timeout.
MySQL .NET Connection String Options. The simplest MySQL connection string for C# is: new MySqlConnection("Server=YOURSERVER;User ID=YOURUSERID;Password=YOURPASSWORD") For all the other options, see the tables below. MySqlConnector supports most of Oracle’s Connector/NET connection options.
Use this one to specify a default command timeout for the connection. Please note that the property in the connection string does not supercede the individual command timeout property on an individual command object. Server = myServerAddress; Database = myDataBase; Uid = myUsername; Pwd = myPassword; default command timeout = 20;
The following code is used to create a MySqlConnection object, assign the connection string, and open the connection. MySQL Connector/NET can also connect using the native Windows authentication plugin.
Use this one to specify the length in seconds to wait for a server connection before terminating the attempt and receive an error.
virtual property int ConnectionTimeout { int get () override; IDbConnection..::. ConnectionTimeout. A value of 0 indicates no limit, and should be avoided in a ConnectionString because an attempt to connect will wait indefinitely. The following example creates a MySqlConnection and sets some of its properties in the connection string.
