Re: ADO error "Invalid Cursor State" after updating Sybase Adaptive Server Anywhere to version 9.0.1.1862

From: Josh Roberts (eyeonsolutions_at_speakeasy.net)
Date: 09/27/04

  • Next message: Brian Bushay TeamB: "Re: Cannot attach to Services Manager" 
    Date: Mon, 27 Sep 2004 15:06:09 -0400

    Kevin:

    I am having the smae exact issue. Did you ever find a solution to this,
    other than using the ODBC driver?

    Thanks
    Josh

    "Kevin Davidson" <kevin@qsinc.com> wrote in message
    news:40e58752$1@newsgroups.borland.com...
    > I'm writing a simple application to read some data from a Sybase database
    > someone sent me. I was progressing pretty well until I installed the patch
    > upgrading it to 9.0.1.1862. After that I started to get this "Invalid
    > Cursor State" error.
    >
    > I am using Microsoft ADO to access the database through the "Sybase
    > Adaptive Server Anywhere Provider 9.0" OLEDB provider. The code is in
    > Delphi 7.
    >
    > The failing statement is the second Open of the dataset--the code goes:
    > Close, Open, Close, Open (fail). The SQL is just a "select * from table
    > where a = :a and b = :b".
    >
    > I could really use a hint on this one as I don't usually work with Sybase.
    >
    > Thanks,
    >
    > Kevin Davidson

  • Next message: Brian Bushay TeamB: "Re: Cannot attach to Services Manager"

    Relevant Pages

    • Re: Need to send a directive to linked database
      ... >I need to insert records into a Sybase database via a linked table. ... tested DSN ODBC connection to the Sybase database ... Without sending that authentication string, ...
      (comp.databases.ms-access)
    • RE: Linked Server -> Distributed query
      ... I am not a sybase user, but using a DSN would mean that you have ODBC on top ... of OLEDB connection. ... > username and password for the Sybase database. ...
      (microsoft.public.sqlserver.programming)
    • Re: Need to send a directive to linked database
      ... Passed the authentication string with no problem. ... >>I need to insert records into a Sybase database via a linked table. ... >database server handle it" ...
      (comp.databases.ms-access)
    • RE: Linked Server -> Distributed query
      ... Thanks John, I tried using an IDS file, but users get the same error still ... > I am not a sybase user, but using a DSN would mean that you have ODBC on top ... >> username and password for the Sybase database. ...
      (microsoft.public.sqlserver.programming)
    • Need to send a directive to linked database
      ... I need to insert records into a Sybase database via a linked table. ... tested DSN ODBC connection to the Sybase database ... Without sending that authentication string, ...
      (comp.databases.ms-access)