Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: New to sql server 2000

    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.

    Any ideas?

    Thanks in advance - kbourg

  2. #2
    Join Date
    Mar 2004

    Re: New to sql server 2000

    Please give an example of a SELECT statement that is giving you an error.

    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts