Error updating Progress from .asp code

tk65tk

New Member
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.
 
Thanks, but that thread shows this

Fixes:
Use SQL server driver

How do you use a SQL driver to connect to Progress?
 
I hoped that it was meaningfull to you because to me it sounded stupid :-)
(In other words I can't help you, just skimmed the KB for a solution that might help)


Casper.
 
Back
Top