I have a SPROC that takes in parameters and uses OpenQuery to create a record in an AS400 DB2 table. It works fine from my development server ( MS/SQL 2008 R2 ) but not from my production server ( MS/SQL 2008 R2 ). The Linked Server to the AS400 is identical on both servers. My production server returns this error:
A syntax error was detected at token .. Token . is not a valid token.
The SPROC is attached.
I'm calling it as follows:
declare @result smallint
exec [dbo].[sprocAS400_Insert] 'VALUE1', 'VALUE-2', 'VALUE-0-3', 'VALUE4', 24, @result OUTPUT
above works fine but only from my test server. The full error message ( also attached ) doesn't give me anything to go on - any suggestions?