Hi,
I have a asp.net application to export from mysql to a txt and recived the error : "Timeout - TextExport::SaveToStream,var:"
My code:
--------------------------------------------------------------------------------------------------------
oleDbConnection1.ConnectionString = "Provider=SQLOLEDB;Data Source=XXXXXXXXXXXX;Initial Catalog=XXXXXX;User Id=XXX;password=XXXXXXXX;Connection Timeout=1800;"
Dim oleDbCommand1 As New System.Data.OleDb.OleDbCommand()
oleDbCommand1.CommandText = "SELECT XXXXXXXXXX"
oleDbCommand1.Connection = oleDbConnection1
Dim txtExport1 As New Spire.DataExport.TXT.TXTExport()
txtExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView
txtExport1.DataFormats.CultureName = "zh-CN"
txtExport1.DataFormats.Currency = "c"
txtExport1.DataFormats.DateTime = "dd/MM/yyyy"
txtExport1.DataFormats.Float = "g"
txtExport1.DataFormats.[Integer] = "g"
txtExport1.DataFormats.Time = "H:mm"
txtExport1.DataEncoding = Spire.DataExport.Common.EncodingType.ASCII
txtExport1.SQLCommand = oleDbCommand1
oleDbConnection1.Open()
txtExport1.ExportType = Spire.DataExport.TXT.TextExportType.CSV
txtExport1.CSVOption.Separator = "|"
txtExport1.CSVOption.AllowQuote = False
txtExport1.
txtExport1.SaveToHttpResponse(arquivoNovo, Response)
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Thanks
Rubens