"Invalid Cursor Error"

"Invalid Cursor Error"

Post by Jong-Yun Moo » Wed, 20 May 1998 04:00:00



Dears

When I try to insert data on the table customer_sites, I encountered the
error of "[Microsoft][ODBC SQL Server Driver]Invalid cursor state". Please
let me know how to solve this error.

Thanks in advance!

 
 
 

"Invalid Cursor Error"

Post by Imran Hussai » Wed, 20 May 1998 04:00:00


This will happen if you try execute an ODBC statement that has not been closed
properly. Make sure you issue a SQLFreeStmt or SQLCloseCursor before opening
it again.

Imran


> Dears

> When I try to insert data on the table customer_sites, I encountered the
> error of "[Microsoft][ODBC SQL Server Driver]Invalid cursor state". Please
> let me know how to solve this error.

> Thanks in advance!

--
===========================================
Imran Hussain
MCP, MCSD

http://www.summitdata.com/imranh
===========================================

 
 
 

1. SQL 7.0 error "Invalid Cursor State"

HI,

I'm developing a DB with SQL 7.0  I've created a table with an integer
field.  Every record has 0 in this field.  I've changed my mind and would
like to change the data type to decimal.  When I attempt to make this
change, I get the "Invalid Cursor State" error.  I've tried deleting the
field and recreating it, with the same result.  The DB and logs are well
below their maximum size limits.

What's going on? Do I need to delete the whole table and re-create it?

TIA,

Ron Walters

2. Limitations in SQL queries

3. "Invalid cursor state" error

4. Open_Server

5. "Invalid cursor state" / Error 0x80004005

6. Problem in linking to read-only tables.......

7. "Ref cursor is invalid"- Oracle, JDBC, Java, and me

8. DTS Import

9. "Invalid cursor state"

10. ODBC "invalid cursor state"

11. trigger error - Invalid Object "Inserted"

12. Snapshot replication gives "Invalid Descriptor Error"

13. "Invalid Attribute/ Option Identifier" Error