Member Avatar for CodeMonkey775
CodeMonkey775 0 Newbie Poster

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? Does it have to do with the carriage returns or line feeds? I had the database in SQL Server 2005 before and it worked fine in that but had to migrate everything to SQL Anywhere 8.

Any help would be great,
Thanks

  • 1 Contributor
  • 0 Replies
  • 79 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.