Symptom
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.
Environment
Crystal Reports XI Release 2
Source : Microsoft Excel
Reproducing the Issue
Ping the database through run command, it cannot open the database
Cause
Database is locked by some other user
Resolution
We have to kill the user session who locked the excel from the network,
(or)
- 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.
Keywords
DAO Error code: 0xc9c Source :DAO.database , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
SAP Crystal Reports XI