Hello everyone,
I have made one website in which there are some crystal reports (SAP), the website is made in visual studio 2010 (4.0 frame work) and using SAP crystal reports. I have made the reports and it works fine when i view them from IDE (visual studio), but i want to make it live, so i tested the reports on IIS (on my machine), everything was working fine but in crystal reports i got this error::
Failed to open the connection. Details: [Database Vendor Code: 18456 ] Failed to open the connection. Details: [Database Vendor Code: 4060 ] Failed to open the connection. rptPOEntry {727AA589-A2A9-439D-BD8E-F100EDE04AC4}.rpt Details: [Database Vendor Code: 18456 ]
I googled many solutions but none was successful, i tried the following solutions
Do the following steps:
1. Open the report in the CR XI designer.
2. Select Database -> Set Datasource Location.
3. Set Datasource Location window will appear and in the replace with section connect to the database and replace these tables with the tables in the current datasource by clicking the update button.
4. After updating close the Set Datasource Location window.
5. Go to 'Database menu' and Click 'Verify Database' and click on ’OK’.
6. Preview the report and the save the report.
But this was not helpful for me... I want to deploy it anyhow on the server. please let me know what all things i need to configure on the server and please also let me know how to resolve the error which occurred on my machine.. (IIS)
Please help me out ...
Thanks in advance,
Regards,
Krunal Panchal