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

From: Kevin Davidson (kevin_at_qsinc.com)
Date: 07/02/04 

Date: Fri, 02 Jul 2004 12:03:34 -0400

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

Relevant Pages

  • Strange ADO.NET/Sybase/Sybase OLEDB problem
    ... we have developed in VB.NET and that accesses a Sybase database using the ... Sybase OLEDB driver via ADO.NET. ... Every morning about 5am, the windows service checks a specified directory, ... MergeData stored proc has started to finish prematurely before it has ...
    (microsoft.public.dotnet.framework.adonet)
  • ADO Error accessing Sybase Adaptive Server Anywhere 0 after installing 9.0.1.1862 patch
    ... I'm writing a simple application to read some data from a Sybase ... installed the patch upgrading it to 9.0.1.1862. ... I am using Microsoft ADO to access the database through the "Sybase ... Adaptive Server Anywhere Provider 9.0" OLEDB provider. ...
    (microsoft.public.data.ado)
  • Re: Dateadd in SQL statement not working
    ... Omigod, I thought you said you were using SQL Server, which is what my ... version of SQL used by Jet, which is the database usually used by Access): ... But my confusion is not totally resolved: Why are you using a Sybase ODBC ... driver to connect to either a Jet or a SQL Server database? ...
    (microsoft.public.inetserver.asp.general)
  • Re: Decouple SQL queries from class in OOP design
    ... then the arguments to the storeCart stored procedure have to be rather ... I have to be familiar with database schema, ... > support returning arbitrary numbers of rows through SELECT statements. ... > SYBASE does support that, and with SYBASE you have a lot of room to ...
    (comp.object)
  • Re: Zombie handles when trapped by a signal
    ... Now that I know that the Sybase ... The concept is to do the execute with a timeout. ... > database server automatically is not correct. ... even after the DBD-Sybase bug is fixed. ...
    (perl.dbi.users)