Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2006

    Question Unanswered: Client Side Cursor with IBM DB OLE and ADO

    Hi. My first post here, so please bare with me. We have a situation where a programmer was able to run an ADO process against one DB2 Z/OS subsystem. But, when he changed to run the process against a a different DB2 Z/OS subsystem, he had problems. The provider is IBMDADB2 - the IBM OLE DB provider. We finally found that if we set the app to use server side cursor (ADO param CursorLocation = adUseServer), then the process works. But we want to be able to use client side cursors.

    There seems to be a parameter or something that is different between the 2 DB2 Z/OS subsystems. Or maybe a DB2 Connect param? CLI param? I've yet to find one. Any ideas?

    DB2 UDB for Z/OS version 710
    DB2 Connect 8.2 fixpak 9

    Texas Farm Bureau Ins. Co.
    Last edited by ju13; 01-18-06 at 13:22.

Posting Permissions

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