Troubleshooting > Troubleshooting DataConnect > Error connecting to Actian Ingres or Actian X
Was this helpful?
Error connecting to Actian Ingres or Actian X
 
Error Code
19
Error Message
Execution ended in error--> Error 19 connecting to 'Actian Ingres (ODBC 3.5)': Exec SQL failed: SQL Statement <SELECT * FROM 'username'.'tablename'>.
Execution ended in error--> Error 19 connecting to 'Actian X': Exec SQL failed: SQL Statement <SELECT * FROM 'Table name'>. Check log for more details.
Description
This error message is displayed for Actian Ingres (ODBC 3.5) or Actian X connector, when the create or drop table syntax during execution is incorrect.
Cause/Solution
Cause: Single quote has been used as the value of IdentifierQuotes property and this results in incorrect create or drop table syntax during execution.
Solution: Change the value of IdentifierQuotes property:
1. Click the Source/Target tab.
2. Change the IdentifierQuotes connector property value from ' (single quote) to None, Default or " (double quotes).
3. Save and Run the Map.
Related Information
Last modified date: 07/26/2024