Invalid Cursor Position

•

What is DaniWeb IT Discussion Community?

You're currently browsing the C# section within the Software Development category of DaniWeb, a massive community of 456,508 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,673 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our C# advertiser: Programming Forums

Thread Tools Display Modes

Views: 826 | Replies: 0

•

Join Date: Jul 2007

Posts: 10

Reputation: CodeMonkey775 is an unknown quantity at this point

Rep Power: 2

Solved Threads: 0

CodeMonkey775 CodeMonkey775 is offline

Offline

Newbie Poster

Invalid Cursor Position

Sep 25th, 2007

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"

Help with Code Tags

(Toggle Plain Text)

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