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/
 


Kirim email ke