ya, connectintimeout=0 emang bisa ngatasi. tapi biasanya masalah ada di jaringannya mas, sehingga ada saat dimana program di client kehabisan waktu untuk koneksinya.
--- Agus Hanapi <[EMAIL PROTECTED]> wrote: > gimana kalo koneksi.ConnectionTimeout = 0 > 'Unlimited ? > ----- Original Message ----- > From: Jenar Suseno > To: [email protected] > Sent: Monday, November 14, 2005 11:18 AM > Subject: [Programmer-VB] Timeout Expaire > Koneksi sql server? > > > Mohon pencerahannya, > > Programku pake koneksi spt ini: > Set koneksi = New ADODB.Connection > koneksi.ConnectionTimeout = 9000 > koneksi.CursorLocation = adUseClient > > StrConec = "Provider=SQLOLEDB.1;Persist > Security > Info=False;User ID=sa;Initial > > Catalog=MyDB;Data > Source=MyServer" > StrConec = StrConec + ";password=123" > > koneksi.Open StrConec > > Di semua komputer client sudah jalan OK, dan gak > masalah. > Tapi Akhir2 ini ada 2 Client yang sering Timeout > Expaire. > > Kira kira pengaruh apa yang menyebabkan 2 client > ini > sering gagal connect? > > Makasih. > > > > __________________________________ > Start your day with Yahoo! - Make it your home page! > > http://www.yahoo.com/r/hs > > > Untuk keluar dari millis ini, kirim email kosong > ke: > [EMAIL PROTECTED] > > > > > > --------------------------------- > YAHOO! GROUPS LINKS > > > Visit your group "Programmer-VB" on the > web. > > To unsubscribe from this group, send an email > to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the > Yahoo! Terms of Service. > > > --------------------------------- > > > > > > > > > --------------------------------- > Yahoo! FareChase - Search multiple travel sites in > one click. __________________________________ Yahoo! FareChase: Search multiple travel sites in one click. http://farechase.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/k7folB/TM --------------------------------------------------------------------~-> Untuk keluar dari millis ini, kirim email kosong ke: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-VB/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
