Error :" Database connector error: "DAO Error code: 0xc9c Source :DAO.database, Description: selected collating sequence not support by the operating system"
When changing the Database connection in the report.
Crystal Reports XI Release 2
Source : Microsoft Excel
Reproducing the Issue
Ping the database through run command, it cannot open the database
Database is locked by some other user
We have to kill the user session who locked the excel from the network,
- Open excel which was locked and save as with a different name.
- Now point the connection of the report to that excel.
- Now the report successfully retrive the data from excel.
DAO Error code: 0xc9c Source :DAO.database , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem