Dan

Dan

  • NA
  • 9
  • 0

Invalid Cursor Position

Sep 25 2007 6:28 PM
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