It took me a while to figure this out so I posted the problem and solution for other people. enjoy.
When trying to run a crystal reports 2013 query using Windows 7 PC on a Linux operating system using IBM informix driver sdk 2.80 I get this error.
SAP crystal reports 2013 errors
Failed to retrieve data from the database .
I hit OK then get this error :
Database connector error : Error -554
Syntax disallowed in this database server .
the problem was when you created the query and do a SHOW SQL QUERY within Crystal Reports
this is the syntax it would show ...
SELECT
cust.cust_cd, cust.cust_nm
FROM
<DBNAME>:informix.cust cust
the problem is : linux does not like the <DBNAME>: that it puts in the FROM section and considers this a syntax error.
This is how I 'fixed' it. There may be a better way in crystal reports but I'm not very familiar with it. This is how I did it.
SOLUTION:
I initially had ibm informix version sdk 3.50 installed
I removed it and re-added 2.80 version but it made no difference.
Open up your query (new or existing)
To edit an existing data source on an existing crystal report query...
Select 'Database'
Select 'Data source location'
You will get a list of your tables in this data source
click the + sign on EACH table name (in the top box) change the
"Overridden qualified table name" to MATCH the actual table name you are on and hit enter to make sure it takes the changes.
Example: if my table name was 'customer' it should appear as
Overridden qualified table name : customer
When all of the tables have been changed click 'Close.
You should now be able to refresh your data and get it to work.
When trying to run a crystal reports 2013 query using Windows 7 PC on a Linux operating system using IBM informix driver sdk 2.80 I get this error.
SAP crystal reports 2013 errors
Failed to retrieve data from the database .
I hit OK then get this error :
Database connector error : Error -554
Syntax disallowed in this database server .
the problem was when you created the query and do a SHOW SQL QUERY within Crystal Reports
this is the syntax it would show ...
SELECT
cust.cust_cd, cust.cust_nm
FROM
<DBNAME>:informix.cust cust
the problem is : linux does not like the <DBNAME>: that it puts in the FROM section and considers this a syntax error.
This is how I 'fixed' it. There may be a better way in crystal reports but I'm not very familiar with it. This is how I did it.
SOLUTION:
I initially had ibm informix version sdk 3.50 installed
I removed it and re-added 2.80 version but it made no difference.
Open up your query (new or existing)
To edit an existing data source on an existing crystal report query...
Select 'Database'
Select 'Data source location'
You will get a list of your tables in this data source
click the + sign on EACH table name (in the top box) change the
"Overridden qualified table name" to MATCH the actual table name you are on and hit enter to make sure it takes the changes.
Example: if my table name was 'customer' it should appear as
Overridden qualified table name : customer
When all of the tables have been changed click 'Close.
You should now be able to refresh your data and get it to work.
