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 [Non-text portions of this message have been removed] -- 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/