Fujitsu cobol and SQLServer

I have a Fujitsu Cobol program connected to an sql server database via odbc.

I have one cursor already open, when I try and open another cursor I get the
following error.

[Microsoft][SQL Native Client]Connection is busy with results for another
command

I think from googling that I need to tell the odbc driver to use server side cursors but have
no idea about how to do this.

Any help gratefully received

Regards
--
Steve

.

Relevant Pages

  • Re: Setting bind variables or defines from applications?
    ... Reopening cursors? ... we use ODBC (and running ODBC in ... Didn't hear of bind variables. ... returning a REF cursor? ...
    (comp.databases.oracle.misc)
  • Re: Multiple-step OLE DB operation generated errors.
    ... If you use an alternate database API (such as ADO or ODBC) rather than ... What is in fact happening is that the database server is, in some cases, ... downgrading or changing the cursor type from what was requested to something ... In the case of requesting a dynamic cursor, ...
    (microsoft.public.data.oledb)
  • Re: date
    ... How to create a cursor object? ... I dont have any VFP database. ... using connection string cnnSinaiRes (ODBC) as follows. ...
    (microsoft.public.fox.vfp.forms)
  • Re: deadlocks when fetching
    ... >> It sounds like you are using a server side cursor. ... recommended in ODBC 3.0 and later. ... But as Andrew mentioned, check your cursor type. ... SQL Server generating a result set and pulling ...
    (microsoft.public.sqlserver.programming)
  • Re: General field?
    ... ODBC automatically convert a Memo field of any type to General. ... >>>I am using a memo field in a VFP8 dbf to hold a bmp file. ... >>> the resulting cursor is a 'General' data type. ...
    (microsoft.public.fox.programmer.exchange)