Hello 9090nez, Coba lihat pada "security" tab dari database "Koperasi"... apakah security nya mixed atau "bukan mixed". (Kalo ngak salah menunya berupa dua option button) mixed dan integrated...
Kalo securitinya mixed, maka login sa bisa dipake... kalo security nya bukan mixed, maka login yang dipake adalah "authorized user " yang login pada server tersebut... jadinya script ADODB hanya bisa dijalankan pada "server" tersebut... ngak akan bisa dijalankan dari client. untuk gampangnya... security di set pada mixed saja.... -- Best regards, DE1929 mailto:[EMAIL PROTECTED] Tuesday, February 21, 2006, 8:39:16 AM, you wrote: > baiknya bikin login baru aja dengan password juga... > kasih permission user id baru tsb bukan cuma sampe db nya, tapi juga sampe > ke tabel nya.. good luck > On 2/20/06, co_rifa <[EMAIL PROTECTED]> wrote: >> >> User Id=sa seperti Script dibawah ini : >> >> >> 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=sa;Password=" >> Set rs = New ADODB.Recordset >> rs.Open "select * from anggota" >> End Sub >> >> >> User Id=sa (adalah User Id Default) >> Kalau anda telah merubah User Id Defaultnya maka User Id nya bukan >> sa lagi >> >> >> --- In ITCENTER@yahoogroups.com, AmiGelz <[EMAIL PROTECTED]> wrote: >> > >> > Klo nvalid authorization mah masalah koneksi kedatabasenya : >> > di MSSQL default usernya adalah 'sa' kalo passwordnya anda sendiri >> yag tau >> > kalo itu masalah permission tabel kali cuba anda cek doeloe >> > >> > >> > regards, >> > >> > AmiGelz[A.K.A]Nurma >> > >> > Pada tanggal 2/20/06, Edi <[EMAIL PROTECTED]> menulis: >> > > >> > > 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 >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > >> > >> > [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 >> >> >> >> >> >> >> > -- > ?-9?9?n?eZ-? > [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/
