Re: [Programmer-VB] koneksi ke SQL server

Andry Hilman Thu, 16 Mar 2006 01:30:25 -0800

maaf nyelak sedikit, saya masih awam dg vb6 begitu juga dg .net cuma dulu saya juga mengalami masalah yg sama, mas pupunk kalau ping dari client ke server mau reply tidak ?
and waktu di .net bisa pakai explorer nya untuk lihat koneksi di sql, kalau di vb 6 ada tidak ya fasilitas seperti itu, maaf kalau tidak bisa banyak membantu.

Ronald Irawan <[EMAIL PROTECTED]> wrote:

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

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.

Relax. Yahoo! Mail virus scanning helps detect nasty viruses!

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.

Re: [Programmer-VB] koneksi ke SQL server

Kirim email ke