mas kalo coding berikut sy jalankan di komptr dmn SQL server sy install, it's OK alias bisa cuman kalo dari client koq masih belum bisa juga ya.... mohon pencerahannya.
Private Sub Form_Load()
Dim cnn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim SQL As String
Set cnn = New ADODB.Connection
cnn.CursorLocation = adUseClient
cnn.Open "provider=SQLOLEDB.1;data source=pegasus;initial catalog=db_gudang;user ID=pupunk;password=234;persist security info=true"
Set rs = New ADODB.Recordset
SQL = "select * from tb_kota"
rs.Open SQL, cnn, adOpenStatic, adLockOptimistic
Set DataGrid1.DataSource = rs
Set rs = Nothing
End Sub
Pada tanggal 3/16/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]
> menulis:
oh iya baru inget, kemungkinan yang nomor 4 punya bung Ronald juga pernah saya alami waktu jaringan dikantor saya bermasalah.
buat Pupunk kemungkinan2nya itu tadi, dicoba aja.
Brgds,
Lim Agus Fitrian
nb:bung Ronald posisi saya di Gaya Motor (deketan nih), siapa tau kapan2 lunch bareng. hue he he he.
Ronald Irawan <[EMAIL PROTECTED]>
Sent by: [email protected]03/16/2006 12:33
[email protected]
[email protected] Re: [Programmer-VB] koneksi ke SQL server
1. Salah pasword/Username
2. SQL nya emang gak ada
3. KAlau ada service nya gak jalan...
kalau semua diatas bukan juga
4. Coba2x nama sqlserver nya diganti pakai IP..
Kalau bisa kemungkinan IP beda Class, dan gak pake DNS ( CMIIW)
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
SPONSORED LINKS
Programmer Indonesia Basic programming language Computer programming languages Programming languages Java programming language
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.
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
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.
