Saya curiga jangan-jangan pake windows autenthication....


Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta



"Purwedi Kurniawan" <[EMAIL PROTECTED]>
Sent by: [email protected]

16/03/2006 04:07 PM

Please respond to
[email protected]

To
[email protected]
cc
Subject
Re: [Programmer-VB] koneksi ke SQL server





tempatmu pake private network ga? coba di ping dulu dari client ke server, nyambung ga?

On 3/16/06, pupunk <[EMAIL PROTECTED]> wrote:
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



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






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




Kirim email ke