Invalid Cursor Position

[TalentedFool]

Help

I get an "Invalid cursor position" when writting away data to the database, any table when I go through an ODBC connection.

If I do the work in query analyzer its fine.

Any thoughts ?

~ Remember - Nothing is Fool Proof to a Talented Fool ~

 

[SQLSister]

Why would you be using a cursor to write data anyway?

Questions about posting. See faq183-874

 

[TalentedFool]

The use of cursors isn't my fault! I'm using a third party app that uses an ODBC to link to the database.

getting rid of the app isn't a way out either!

I'm convinced it's something to do with XP SP2. I've opened up 1433 and 1434 and still no joy! but it shouldn't effect it in reality as the db and app are both on my machine.



~ Remember - Nothing is Fool Proof to a Talented Fool ~

 

[SQLSister]

Well if you think it has to do with sp2, then I would uninstall that service pack and see if it still fails. At least then you will know if that is the problem.

Sounds like a problem with maintaining the connection, maybe it is timing out? Have you checked with the vendor? Maybe they are aware of and know the solution to the problem.

Questions about posting. See faq183-874