0
Answer

Invalid Cursor Position

Dan

Dan

17y
3.2k
1
Hi,
I'm trying to access XML data in C# I have stored in a row in a database under one column. My database software is Sybase SQL Anywhere 8.

The code is as follows"

OleDbDataAdapter da = new OleDbDataAdapter("SELECT UIData FROM prog_parents WHERE ParentName = 'Blank Panel'", connection);
da.Fill(ds);

The error occurs when it tries to fill the dataset. The error is:
OLEDBEXCEPTION: Invalid Cursor Position

Is there some incompatibility with SQL Anywhere 8 and XML? I had the database in SQL Server 2005 before but had to migrate it to SQL Anywhere 8.

Any help would be great,
Thanks