| 
Mas Pupunk,
Kalo udah di ping dan tersambung berarti network
ok, kalo masih enggak bisa connect coba check hal dibawah :
Di tempat client ada mdac nya enggak ? jangan
jangan waktu bikin setup di VB enggak di ikutkan copy MDAC .........
Sehingga waktu install di tempat client, enggak ada
MDAC........
Coba dech di computer client di check udah
terinstall MDAC apa belum ....?
Salam
Eko Suharto
----- Original Message -----
Sent: Thursday, March 16, 2006 1:07
AM
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
YAHOO! GROUPS LINKS
Yahoo! Mail
Bring photos to life! New PhotoMail makes sharing a breeze.
|
