We have a problem with one of our Coldfusion MX7 applications generating a database error when a user chooses the Add Button to add an event to the database. The error is as follows:
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '='.
Message Error Executing Database Query.
We have this same application with the exact same code deployed on four web servers where it works just fine and does not generate an error. Tracing determined that the problem server calls the SQL database with an sp_prepare call for the stored procedure. Our DBA feels that this is what is causing the problem because the other servers where the applicaiton works consistently do not call the SQL server with sp_prepare.
I've compared the settings in our Coldfusion administrator with the other servers and they are the same. I've also verified that the Coldfusion drivers match on all the servers.
The developer does not want to change their code because the application works consistently on four servers. The developer feels that the problem is something to do with the server environment.
Does anyone have any suggestions on how to resolve this issue?