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

From: Frank C. (frankc_at_hotmail.com)
Date: 07/02/04 

Date: Fri, 2 Jul 2004 16:18:26 -0300

Try ADO+ODBC instead of Sybase OLEDB.

> 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

  • 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)
  • ADO error "Invalid Cursor State" after updating Sybase Adaptive Server Anywhere to version
    ... 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. ...
    (borland.public.delphi.database.ado)
  • 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)
  • 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)