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/