Results 1 to 4 of 4

Thread: error in crystal report

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Jul 2006
    Location
    /root/usr/local/bin
    Posts
    476

    error in crystal report

    hello!
    when i try to view the report it shows this error

    COMException was Unhandled

    Logon failed.
    Details: DAO Error Code: 0xbd0
    Source: DAO.Workspace

    any idea how to solve this?

    tnx a lot

  2. #2

    Thread Starter
    Hyperactive Member
    Join Date
    Jul 2006
    Location
    /root/usr/local/bin
    Posts
    476

    Re: error in crystal report

    ConnectionInfo connInfo = new ConnectionInfo();
    connInfo.DatabaseName = Application.StartupPath + "\\CQSTest.mdb";
    connInfo.ServerName = Application.StartupPath + "\\CQSTest.mdb";
    connInfo.UserID = "Admin";
    connInfo.Password = "1234567";

    ReportDocument crDocument = new ReportDocument();
    crDocument.Load(Application.StartupPath + @"\crChart_MV.rpt");
    Database crDB = crDocument.Database;
    Tables crTables = crDB.Tables;
    foreach (Table crTable in crTables)
    {
    TableLogOnInfo crLogOnInfo = crTable.LogOnInfo;
    crLogOnInfo.ConnectionInfo = connInfo;
    crTable.Location = Application.StartupPath + "\\CQSTest.mdb";
    crTable.ApplyLogOnInfo(crLogOnInfo);
    }
    fPrintPreview.crystalReportViewer1.ReportSource = crDocument;

    fPrintPreview.ShowDialog();


    error:
    Logon failed.
    Details: DAO Error Code: 0xbd7
    Source: DAO.Workspace
    Description: Not a valid password.
    Unable to connect: incorrect log on parameters.

    i think the parameters are right...
    or if wrong what is the correct parameters?

    tnx

  3. #3
    Addicted Member mabbas110's Avatar
    Join Date
    Oct 2005
    Location
    Karachi , Pakistan
    Posts
    172

    Re: error in crystal report

    Please try once by running directly trough crystal report and if u get any error then resolve that and u will find ur solution. Normally this happens when i change my database name or update proc.
    Thanks and Regards,

    Muhammad Abbas

  4. #4

    Thread Starter
    Hyperactive Member
    Join Date
    Jul 2006
    Location
    /root/usr/local/bin
    Posts
    476

    Re: error in crystal report

    i don't have crystal report
    i do this in VS2005 and it has built in crsytal report
    that error shows if my ms access database has password but
    if no password it works fine.

    any example?

    it seems that crsytal report has still bug or hard to connect with secure password?
    in Data Environment in VB6, its easy just give the connection string and i will work without headache

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