-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Edi
Sent: Monday, February 20, 2006 2:30 PM
To: [email protected]
Subject: [ITCENTER] Fw: Tidak bisa koneksi ke SQL Server 2000
Saya sedang mencoba koneksi data ke sql server2000 menggunakan VB6, perintah
yg saya gunakan seperti dibawah ini tapi selalu error yg pesannya sbb =
Invalid authorization specification...
Kira2 dimana letak salahnya, apa karena saya tidak memasukan User ID dan
password, kalo memang betul User ID dan password apa yg harus saya masukkan
(SQL Server atau Windows Server)...
>Dim cn As ADODB.Connection
>Dim rs As ADODB.Recordset
>Private Sub Form_Load()
> Set cn = New ADODB.Connection
> cn.Open "Provider=SQLOLEDB;" & _
> "Data Source=Diva-serv" & _
> "Initial Catalog=Koperasi" & _
> "User Id=;Password="
> Set rs = New ADODB.Recordset
> rs.Open "select * from anggota"
> ....
> ....
>End Sub
>Rgds,
>Edi
perhatikan tanda ";"
Cn.Open "Provider=SQLOLEDB.1;" & _
"User ID=sa;" & _
"Password=;" & _
"Initial Catalog= Koperasi;" & _
"Data Source=xyz"
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
:: Hapus bagian yang tidak perlu (footer, dst) saat reply! ::
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##
$$ Iklan/promosi : www.itcenter.or.id/sponsorship $$
[@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
