Crystal Reports connection to SQL Server database
source link: https://community.sap.com/t5/technology-q-a/crystal-reports-connection-to-sql-server-database/qaq-p/13606202
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Thursday
Hello,
We are testing Crystal Reports to create and put on line paginated reports that use SQL Server data. At this point, we use free trial versions. I can create a CR 2020 report on my PC using an ODBC connection to SQL Server, everything works fine including database requests to change report parameters.
We then installed SAP BusinessObjects BI 4.3 version 14.3.3.4562.3 (still the trial version) on a dedicated server to publish the report and make it available company wide. We created the same ODBC profile server-side as on my PC, same name, same driver (SQL native), same server, same database user and password. The ODBC connection works fine on the server. The report database connection is setup accordingly in the Central Management Console (sorry it's in French) :
I can access the report online but when I try to run it with new report parameters I get this message : Unable to start connection Error code:0 [CRWEB00000119]
I tried pretty much all options in the CMC parameters with no success. Any help will be appreciated.
Regards,
Philippe
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK