setelah sy coba pakai win server 2000 ternyata sekarang udah bisa.
berikut codingnya, tp jika msh ada yg kurang benar mohon masukannya.
Option Explicit
Dim cnn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim SQL As String
Private Sub Form_Load()
Set cnn = New ADODB.Connection
cnn.CursorLocation = adUseClient
cnn.Open "Provider=SQLOLEDB.1;Password=234;Persist Security Info=True;User ID=pupunk;Initial Catalog=db_gudang;Data Source=
192.168.10.15\PEGASUS"
Set rs = New ADODB.Recordset
SQL = "select * from tb_produk"
rs.Open SQL, cnn, adOpenStatic, adLockOptimistic
Set DataGrid1.DataSource = rs
Set rs = Nothing
End Sub
pupunk
Pada tanggal 3/16/06, yusup andrias <[EMAIL PROTECTED]> menulis:
mas pupunk kalo error nya di coding tsb coba cek, apakah ada kesalahan pada datasource, user id, password??apakah sama dgn konfigurasi datasource, user id, pass?saya pernah ada masalah spt diatas, mslnya harusnya untuk datasource = NB, user id = x, dan pass = y..tapi saya tertulis datasource = SS, user id = x, dan pass = y..jd muncul pesan error itu...semoga bisa membantu...
Brings words and photos together (easily) with
PhotoMail - it's free and works with Yahoo! Mail.
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.
