Troubleshooting > Troubleshooting DataConnect > Error executing create table SQL statement
Was this helpful?
Error executing create table SQL statement
 
Error Code
7
Error Message
Execution ended in error--> Error preparing map for execution: Error 25507 opening target ‘MySQL (ODBC 3.5)': Exec SQL failed: SQL Statement <CREATE TABLE 'table name’ ('ColumnName1' DataType, 'ColumnName2' DataType,'ColumnName3' DataType>.
Description
This error message is displayed for MySQL (ODBC 3.5) Target 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 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
MySQL (ODBC 3.5)
 
 
Last modified date: 10/22/2024