di sini mas, dan errornya itu seperti yg sy capture tadi.
con.Open "provider=SQLOLEDB.1;data source=pegasus;initial catalog=db_gudang;user ID=pupunk;password=234;persist security info=true"
nb: authenticationnya sdh pakai SQL and windows.
Pada tanggal 3/16/06, Ronald Irawan <[EMAIL PROTECTED]> menulis:
Coba di debug..
baris mana yg menyebabkan error?
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 02:50 PM
[email protected]
[email protected] Re: [Programmer-VB] koneksi ke SQL server
sy udah coba connect lewat IP tp msh blm bisa jg. IP pegasus 192.168.10.15, sy pakai 192.168.10.20. mohon pencerahannya donk.....
Pada tanggal 3/16/06, Ronald Irawan < [EMAIL PROTECTED]> menulis:
Btw : setelah saya liat, mungkin nempatin cursor locationnya yg salah,,,
jadi belum di open, sudah di set ( saya kurang tahu apakah ini ada pengaruhnya / tdk ),tapi coba di balik
Private Sub Form_Load()
Dim cnn As ADODB.Connection
Set cnn = New ADODB.Connection
cnn.Open "Provider=SQLOLEDB.1;Password=123;Persist Security Info=True;User ID=pupunk;Initial Catalog=db_gudang;Data Source=pegasus"
cnn.CursorLocation = adUseClient
End Sub
Kalau mash blm bisa, seperti email saya sebelumya
1. Salah pasword/Username
--Coba jalankan query analyzer menggunakan userID Pupunk dan pasword 123 bisa gak ?
2. SQL nya emang gak ada
--Install SQL nya seperti apa ? kalau sql 2K, apakah kamu next next terus ? kalau iya
kemungkinan besar menggunakan windows autentication, berarti user windows yg anda gunakan,
mesti di daftarkan di Server anda ( CMIIW)
3. KAlau ada service nya gak jalan...
Jalankan service nya, click kanan, start
kalau semua diatas bukan juga
4. Coba2x nama sqlserver nya diganti pakai IP..
Kalau bisa kemungkinan IP beda Class, dan gak pake DNS ( CMIIW)
--Coba Conectnya lewat IP, jadi pegasus itu IP nya berapa?
CMIIW
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
[EMAIL PROTECTED]
Sent by: [email protected]16/03/2006 01:38 PM
[email protected]
[email protected] Re: [Programmer-VB] koneksi ke SQL server
coba periksa driver di ODBC nya uda terinstal belum, trus periksa juga userid dan password utk SQL server uda bener belum.
kalo pas instal SQL server, pilih tipe otentifikasinya Windows Authentication atau Mixed Mode? (sorry lupa istilah aslinya, pokoknya kurang lebih gitu deh)
Kalo pilihnya windows auth. loginnya pake login windows dan harus terdaftar di server (tempat sql server diinstal).
kalo saya lebih suka pake Mixed Mode soalnya kita tinggal bikinin login utk sql serv nya dan program yang ngatur aksesnya.
kalo semuanya uda ok dan masih bermasalah, coba bikin pake ADODC dan setting langsung connection stringnya, trus tinggal copy paste aja conn stringnya n bandingin ama yang kita buat.
smoga mbantu
Brgds,
Lim Agus Fitrian
pupunk < [EMAIL PROTECTED]>
Sent by: [email protected]03/16/2006 12:01
[email protected]
[email protected] Re: [Programmer-VB] koneksi ke SQL server
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
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.
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.
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.
