Results 1 to 1 of 1

Thread: problem in connection with crystal report9

  1. #1

    Thread Starter
    New Member
    Join Date
    Jan 2008
    Posts
    2

    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
  •  



Click Here to Expand Forum to Full Width