I am running MySQL Server 5.0 along with ASP.Net 2.0 with VS 2005.
I am getting a timeout error when reaching 30 seconds between mysql and the datasource control.
I have defined the control in my aspx page like so...
"
datasourcemode="DataSet"
providerName="CoreLab.MySql" />
In my webconfig file my connectionstring is like this:
In my vb.net code behind..I populate the datasource control with a string like so:
DataSource.SelectCommand = "queryString"
The mysql query takes about 70 seconds from mysql to run....asp.net timesout at 30..which I believe is the defaul for the command timeout..
I cannot figure out how to change the command timeout...
I am still running my trial version..
Please help.
CommandTimeOut Error : ASP.net 2.0 DataSource controls and MySQL
I Do not have timeout as an option to choose from...
these are what im importing:
Am I missing something?
Imports System.Data.SqlClient
Imports System.data
Imports System.Drawing
Imports System.Configuration.AppSettingsSection
Imports System.IO
Imports System.Runtime.Serialization
Imports System.Diagnostics
Imports CoreLab.MySql
these are what im importing:
Am I missing something?
Imports System.Data.SqlClient
Imports System.data
Imports System.Drawing
Imports System.Configuration.AppSettingsSection
Imports System.IO
Imports System.Runtime.Serialization
Imports System.Diagnostics
Imports CoreLab.MySql
Actually I found a way around it.
Here is my code....
Protected Sub DataSource_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles DataSource.Selecting
e.Command.CommandTimeout = 200
End Sub
This changes the timeout on the command....when using a sqldatasource control.
Here is my code....
Protected Sub DataSource_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles DataSource.Selecting
e.Command.CommandTimeout = 200
End Sub
This changes the timeout on the command....when using a sqldatasource control.