Seharusnya pake SetLogonInfo, kira2 begini, saya lupa tepatnya gimana: laporan.Database.Tables(0).SetLogonInfo ....
--- In [email protected], "Development, ID-IT" <ID- [EMAIL PROTECTED]> wrote: > > Dear All, > > > > Ada titpan pertanyaan dari rekan saya: > > > > saya sedang mendevelop aplikasi memakai Visual Basic 6 dengan database > SQLServer 2005 dan Crystal Report XI Developer, saya ketemu masalah > sewaktu akan menampilkan reportnya. > > > > Pada Project saya tambahkan componet serta References: > > Crystal AxtiveX Report Viewer Library 11.0 (Components) > Crystal Reports ActiveX Designer Design and Runtime Library 11.0 > (References) > > > > Pada command di formnya saya menulis : > > '------------------------------------------------------------------- ---- > --- > > Dim app as new CRAXDDRT.Application > Dim laporan as new CRAXDDRT.report > app.logonServer "p2ssql.dll","SERVER1","DATABASE1","sa","MYPASSWORD" > > > > set laporan = app.openreport("Daftar1.rpt") > CrystalActiveXReportViewer1.reportSource = laporan > CrystalActiveXReportViewer1.viewReport > > '------------------------------------------------------------------- ---- > ---- > > "Daftar1.rpt" saya buat dengan koneksi OLE DB (ADO) (Microsoft OLE DB > Provider for SQL Server) > > > > setelah saya jalankan (F5) projectnya kok muncul form yang meminta > password untuk user "sa", terus saya isi, baru muncul reportnya. Padahal > kalau > kita lihat pada sintaks diatas kan sudah kita tulis passwordnya, yaitu > MYPASSWORD. > > Apa ada kesalahan/kekurangan dalam sintak codenya /pengambilan component > /references ? > > > > Ada yg bisa Bantu? > > > > Thanks sebelumnya > > > > Yosafat > > > > > ---------- > > This email is confidential. If you are not the addressee tell the sender immediately and destroy this email > without using, sending or storing it. Emails are not secure and may suffer errors, viruses, delay, > interception and amendment. Standard Chartered PLC and subsidiaries ("SCGroup") do not accept liability for > damage caused by this email and may monitor email traffic. > > > [Non-text portions of this message have been removed] >
