Kayaknya kamu salah Penulisan CN dan CNN
Kamu Create Pub Use CN
Trus U/ Connect Km Use CNN
Ga nyambung deh..
Moga membantu

> Darm <[EMAIL PROTECTED]> wrote:
>   Salam
> 
> Saya pemuda dalam Visual basic, 
> Ketika saya menghubungkan VB dengan SQL server, 
> terjadi kesalahan dan muncul pesan errror:
> Run-time error '3709':
> The connection cannot be used to perform this
> operation, It is either closed or invalid in this
> context
> 
> listing nya seperti dibawah ini:
> 
> Public CN As New ADODB.Connection
> 
> CN.ConnectionString = "Provider=SQLOLEDB.1;Persist
> Security Info=False;User ID=sa;Password=;Initial
> Catalog=Perpus"
> CN.Open
> ctype = adOpenStatic
> clocation = aduserserver
> 
> 
> Set AdoLogin = New ADODB.Recordset
> AdoLogin.Open "Select * from tUser where Pengguna =
> '" & txtUser.Text & "'", CNN, adOpenStatic,
> adLockReadOnly
> 
> keselahan pada AdoLogin.open
> "select..............................
> 
> Mohon bantuannya... kekurangan listingnya apa dan
> kurang apa...
> 
> Terimakasih
> 
> [Non-text portions of this message have been
> removed]
> 
> 
> 
> Untuk berhenti berlangganan kirim email kosong ke :
> [EMAIL PROTECTED]
> 
> Ikuti juga forum diskusi VB.net dengan 
> mengirim email kosong ke
> [EMAIL PROTECTED]
> 
> 
> 
> 
>   SPONSORED LINKS 
>         Computer internet security   Computer
> internet business   Computer internet access    
> Computer internet privacy securities   Computer
> internet help   Computer internet connection 
>     
> ---------------------------------
>   YAHOO! GROUPS LINKS 
> 
>     
>     Visit your group "indoprog-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! Mail
>  Use Photomail to share photos without annoying
> attachments.
> 
> [Non-text portions of this message have been
> removed]
> 
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED]

Ikuti juga forum diskusi VB.net dengan 
mengirim email kosong ke [EMAIL PROTECTED]
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/indoprog-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