OleDb TimeOut Pb

[Herve MAILLARD]

Hi,

I use an OleDbDataAdapter :
OleDbConnection MyCon = new OleDbConnection("Provider='SQLOLEDB.1';Persist
Security Info=False;User ID=sa;Initial Catalog=REPORT_VENT;Data
Source=(local);Use Procedure for Prepare=1;Auto Translate=True;Packet
Size=4096;Workstation ID=HERVE;Use Encryption for Data=False;Tag with column
collation when possible=False;");

MyCon.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM
MyTable,MyCon);
myCommand.Fill(MasterDataSet,"Data_var") ;
MyCon.Close();

Of course the SQL_code is a little bit more complex...

This code is call by a Web Page.
When SQLServer take too much time before answer, I get a TimeOut error...

How can I suppress the TimeOut error ?

I have try to add Connection Timeout = 0 in the cnx string with no effect.

Thanks for your help.

H. MAILLARD