CrystalReportsNinja Database logon failed Windows OS

[itsoftsaeed]

First try

25-08-2022 16:58:04 Report loaded successfully
25-08-2022 16:58:04 Output Filename : test.pdf
25-08-2022 16:58:04 Output format : pdf
25-08-2022 16:58:04 Exception: Database logon failed.
25-08-2022 16:58:04 Inner Exception: System.Runtime.InteropServices.COMException (0x8004100F): Database logon failed.
at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)
at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)

second try

25-08-2022 18:09:34 ================== LoadReport, Output File and DB logion ===========
25-08-2022 18:09:34 Report news.rpt loaded successfully
25-08-2022 18:09:34 Output Filename : test.pdf
25-08-2022 18:09:34 Output Format : pdf
25-08-2022 18:09:34 Logging into SQLDBNAME Database on SQLSERVERNAME with User id: REPORTUSERNAME with Integrated Security = False
25-08-2022 18:09:34
25-08-2022 18:09:34 ================== ProcessParameters ===============================
25-08-2022 18:09:34 Number of Parameters detected in the report = 0
25-08-2022 18:09:34
25-08-2022 18:09:34 ================== STEP = PerformOutput ============================
25-08-2022 18:09:34
25-08-2022 18:09:34 ===================Logs and Errors =================================
25-08-2022 18:09:34 Message: Failed to open the connection.
news 12900_5760_{57B50DE2-FB79-4D16-B43C-F47FE03B5111}.rpt
25-08-2022 18:09:34 HResult: -2147221760
25-08-2022 18:09:34 Data: System.Collections.ListDictionaryInternal
25-08-2022 18:09:34 Inner Exception: System.Runtime.InteropServices.COMException (0x800002F4): Failed to open the connection.
news 12900_5760_{57B50DE2-FB79-4D16-B43C-F47FE03B5111}.rpt
at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)
at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
25-08-2022 18:09:34 StackTrace: at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e)
at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export()
at CrystalDecisions.CrystalReports.Engine.ReportDocument.Export()
at CrystalReportsNinja.ReportProcessor.PerformOutput()
at CrystalReportsNinja.ReportProcessor.Run()
25-08-2022 18:09:34 ====================================================================

when I try to run with 32bit OS the report is working successfully, but try to run with 64Bit OS, the following error occurred Exception: Database logon failed...................., similarly I cannot deploy on remotely window server 2019 64Bit OS, same problem facing.... here try to connect with MYSQL database
my parameters in Command Line are:
D:\Web\xampp\htdocs\cr>CrystalReportsNinja -U"dw01_wit" -P"_khan&&bro" -F news.rpt -S"localhost" -D"dw01_wifaq" -O test.pdf -E pdf
OR
also try as given below
D:\Web\xampp\htdocs\cr>CrystalReportsNinja.exe -U dw01_wit -P password -F news.rpt -S localhost -D dw01_wifaq -O test.pdf -E pdf

I try to connect with mysql database through ODBC 32bit drivers .......

When I try to run simple report without adding any table into the report ..... it connected successfully.
parameters in Command Line are:
CrystalReportsNinja -F r6.rpt -O test.pdf -E pdf
Report loaded successfully
Database Login done
Completed

ninja-20220825165802.log

any one can help me, to solve this problem how connect with CrystalReportsNinja, with credentials parameters , adding tables into the report through MYSQL odbc deriver.. ?