I am porting a production general ledger application from Informix to sql server 2000. I used Powerbuilder 8.0.4 to develop it.
The application works fine, except for some of the embedded SQL. The singleton selects work fine if they reference the default transaction object. However, if I add the 'using' clause to the select to specify the transaction object, the select fails with error 16945 - The cursor was not declared.
Microsoft's site says to upgrade to the latest version of MCAD connectivity tools. Have done this and error still there.
Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!
Or try our Ask An Expert service to answer any of your questions!