setting di SQLnya, timeout diganti jadi 0 (unlimited)
________________________________ From: wempykurnialim <[email protected]> To: [email protected] Sent: Wed, May 19, 2010 6:42:13 PM Subject: [programmer-vb] Re: error time out coba pake trigger aja, klo data kebanyakan 'n resource computer nya kurang emang biasanya gitu :D --- In [email protected], khaled talaat <kh_tal...@...> wrote: > > To resolve this set (timeout=0) in connectionstring as ex: > > timeout=0;Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security > Info=False;Initial Catalog=DatabaseName;Data Source=.\sqlexpress > > --- On Tue, 5/11/10, Ola <stikom.bo...@...> wrote: > > From: Ola <stikom.bo...@...> > Subject: [programmer-vb] error time out > To: [email protected] > Date: Tuesday, May 11, 2010, 9:49 AM > > > > > > > >  > > > > > > > > > >  > > > aku punya error sbb >  > See the end of this message for details on invoking > > just-in-time (JIT) debugging instead of this dialog box. >  > ************ ** Exception Text > ************ ** > MySql.Data.MySqlCli ent.MySqlExcepti on: Timeout expired. > The timeout period elapsed prior to completion of the operation or the server > is > not responding. ---> System.TimeoutExcep tion: A connection attempt failed > because the connected party did not properly respond after a period of time, > or > established connection failed because connected host has failed to respond > ---> System.IO.IOExcepti on: Unable to read data from the transport > connection: A connection attempt failed because the connected party did not > properly respond after a period of time, or established connection failed > because connected host has failed to respond. >  > tapi kalo di seting koneksinya di buat timeout=60 > ngak ada masalah >  > masalahnya proses menjadi lambat, adakah > cara lain untuk mengatasi masalah ini >  >  > oL4 >
