We are wanting to use Crystal Reports to generate customer UCCX Reports. The 1st level of effort was to locate, install and configure the Informix ODBC driver without loosing more hair. Once that was done we were able to connect with Crystal reports and assume that all was good... However! We wanted to leverage the resource table to in our customer report but got weird error messages:
"Failed to retrieve data from the database.
Details: 42000:[informix][informix ODBC Driver][Informix]A syntax error has occurred. [Database Vendor Code: 201]
General searches on the internet we all over the place... so I tried browsing the data with Excel using the Informix ODBC Driver and got the following error when accessing the resoure table in UCCX:
"[Informix][Informix ODBC Driver]Restricted data type attribute violation.
This message seems to point to a permissions issue, so i checked the privs on the table and uccxhruser has "select" permissions
Has anyone else run into this issue? Any and all assistance is appreciated.
j.
