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
Can you please give us some more information, e.g. some screenshots and the exact sql as it is sent by the SQLExecutor?
+18- Contributor
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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.