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
| pupunk <[EMAIL PROTECTED]>
Sent by: [email protected] 16/03/2006 12:01 PM
|
|
mas agus, koq error ya..... (terlampir). apa ada yg salah ? atau ada yg harus diotak-atik si SQL servernya ?
Private Sub Form_Load()
Dim cnn As ADODB.Connection
Set cnn = New ADODB.Connection
cnn.CursorLocation = adUseClient
cnn.Open "Provider=SQLOLEDB.1;Password=123;Persist Security Info=True;User ID=pupunk;Initial Catalog=db_gudang;Data Source=pegasus"
End Sub
thx
pupunk
Pada tanggal 3/16/06, [EMAIL PROTECTED] <[EMAIL PROTECTED] > menulis:
Kalo saya suka pake ADODB kaya gini :
Dim con as ADODB.Connection
Set Con = New ADODB.Connection
Con.Open "Provider=SQLOLEDB.1;Password= pwd;Persist Security Info=True;User ID=u_id;Initial Catalog= db_name;Data Source=comp_name "
ganti yang diberi warna merah dengan informasi yang benar.
misal saya mau konek ke SQL Server yang ada di komp bernama KOMPAGUS dengan nama databasenya DBGUDANG trus userid agus dan password 12345
Con.Open "Provider=SQLOLEDB.1;Password=12345;Persist Security Info=True;User ID= agus;Initial Catalog=DBGUDANG ;Data Source=KOMPAGUS"
menyertakan atribut password di connection string itu optional tergantung kebutuhan dan faktor keamanan.
semoga membantu
Brgds,
Lim Agus Fitrian
| pupunk <[EMAIL PROTECTED]>
Sent by: [email protected] 03/16/2006 09:42
|
|
dear temen2x semua,
sy baru beralih & msh tahap belajar menggunakan SQL server 2000 (versi
desktop). yang ingin sy tanyakan bgm cara (coding) membuat koneksi ke SQL
server tsb yg sy install di komptr lain ?
mohon bantuannya ya....
thx b-4
pupunk
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.
[attachment "error1.jpg" deleted by Ronald Irawan/IT/sanghiang]
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.
