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.
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? sprocAS400_Insert.sql.txt sprocError.txt
DB2Microsoft SQL Server 2008SQL
Last Comment
Vitor Montalvão
8/22/2022 - Mon
ste5an
Why not using the DATETIME value directly, instead of you manual conversion?
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.