Hi , I am getting this error message from my SQl Executor in FME. The Sql runs fine in MS studio Manager
(-2147467259) Unknown token received from SQL Server'
I am using a StringConcatenator for the script which passes the result to SQLExecutor
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- 8394 replies
Can you please give us some more information, e.g. some screenshots and the exact sql as it is sent by the SQLExecutor?
+22- Contributor
- 2179 replies
Is your SQL statement ending with a semicolon?
This can cause an error in the SQLExecutor.
+1No There was no semi colon but I did put in a new line in the StringConcatenator and the error has gone away.
