|
-
Jan 31st, 2008, 02:42 AM
#1
Thread Starter
New Member
problem in connection with crystal report9
Hi ,
i m shruti,
I m using vb6 and Ms Access 2000,Crystal report9,
For reporting i m using CRviewer91,
here i is my code,it gives error as Logon failed details:DAO error code :0xbd7 source:DAO.workspace description:not a valid password
Code:
Dim ConnectionInfo As CRAXDDRT.ConnectionProperties
Dim test As String
str = App.Path & "\CrystalReport2.dsr"
test = App.Path & "\DB\Utm.mdb"
Set App1 = New CRAXDRT.Application
Set Report1 = Report.OpenSubreport("CrystalReport1")
Set Report1 = Report.OpenSubreport("CrystalReport1 - 01")
Set Report1 = Report.OpenSubreport("CrystalReport1 - 02")
Set Report1 = Report.OpenSubreport("CrystalReport1 - 03")
Set Report1 = Report.OpenSubreport("CrystalReport1 - 06")
Set Report1 = Report.OpenSubreport("CrystalReport1 - 07")
Set Report1 = Report.OpenSubreport("CrystalReport1 - 08")
For n = 1 To Report1.Database.Tables.Count
Set ConnectionInfo = Report1.Database.Tables(n).ConnectionProperties
Report1.Database.Tables(n).DllName = "crdb_dao.dll"
Report1.Database.Tables(n).SetLogOnInfo "", App.Path + "\DB\Utm.mdb", "Admin", "becool"
Report1.Database.Tables(n).SetSessionInfo "", Chr$(10) & "becool"
Report1.Database.Tables(n).Location = App.Path + "\DB\Utm.mdb"
Next n
On Error Resume Next
ConnectionInfo.DeleteAll
str1 = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;" & _
"DATA SOURCE= " & App.Path & "\DB\UTM.MDB;" & _
"JET OLEDB:SYSTEM DATABASE=C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\SYSTEM.MDW"""
ConnectionInfo.Add "Database Provider", "MICROSOFT.JET.OLEDB.4.0"
ConnectionInfo.Add "Database ConnectionString", str1 '"Provider=MSDASQL.1;User ID=Admin;Data Source=MS Access Database;Initial Catalog= " & App.Path & "\DB\Utm.mdb;"""
ConnectionInfo.Add "Database Name", test
ConnectionInfo.Add "Databse Password", "becool"
ConnectionInfo.Add "Session UserID", "Admin"
ConnectionInfo.Add "Session Password", "becool"
ConnectionInfo.Add "System Database Path", "C:\Program Files\Microsoft Office\Office\SYSTEM.MDW" 'App.Path & "\DB\Utm.mdb" '"C:\Program Files\Microsoft Office\Office\System.mdw" 'gstrDBLoc & "\Security.mdw"
Set Report1 = App1.OpenReport(str, 1)
CRViewer91.ReportSource = Report1
CRViewer91.Refresh
CRViewer91.Zoom (10)
CRViewer91.PrintReport
CRViewer91.ViewReport
Report1.DiscardSavedData
Sleep (500)
CRViewer91.ViewReport
zoomcount = 0
Report1.DiscardSavedData
Timer1.Enabled = True
zoomcount = 0
Screen.MousePointer = vbDefault
pls help me
Last edited by si_the_geek; Jan 31st, 2008 at 05:50 AM.
Reason: added code tags
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|