From an .asp application i am updating records in a SQL 2005 database with a linked server to the Progress database using the ODBC driver (DATADIRECT 4.10 32-BIT Progress SQL92v9.1E). The records sometimes update with no troubles and other times they error, throwing the following
---------------------------
Windows Internet Explorer
---------------------------
Error Modifying Work Order, Error number = -2147217900 [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near
---------------------------
OK
---------------------------
Notice the 'near' there is nothing there. The frustrating part is it works and then doesnt.
Using SQL Profiler i can capture the actual SQL (its calls stored procedures) and run those in Managment Studio and all works perfectly.
So it has to be something in the ODBC connection right?
Any suggestions/help would be greatly appreciated.
Thanks.
---------------------------
Windows Internet Explorer
---------------------------
Error Modifying Work Order, Error number = -2147217900 [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near
---------------------------
OK
---------------------------
Notice the 'near' there is nothing there. The frustrating part is it works and then doesnt.
Using SQL Profiler i can capture the actual SQL (its calls stored procedures) and run those in Managment Studio and all works perfectly.
So it has to be something in the ODBC connection right?
Any suggestions/help would be greatly appreciated.
Thanks.