kayaknya semua masalah bisa di tanyakan ke paman GOOGLE
  ketik aja "script for connect from vb 6.0 to SQL SERVER"
   
   
  

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]



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