da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: MSSQL Invalid cursor state

Forum List » AnyDAC » v 1.x General English

rt
User

Senior Boarder

Posts: 24

Karma: 0

MSSQL Invalid cursor state

Posted: 2008/03/13 04:36

Hi!

I using AnyDac to connect MS SQL servers. When I connect MS SQL 2000 servers my application work properly but if i want to use the same application on MS SQL 2005 server i always get "invalid cursor state" error. I also try to set drivername to MSSQL200 and MSSQL2005 but i got the same error. What I doing wrong?

Regards RT

Diman

Admin

Posts: 1461

Karma: 18

Re:MSSQL Invalid cursor state

Posted: 2008/03/13 04:49

1) Do you have explicit transaction control in your application ?
2) Do you have SQL Native Client installed on workstation, when you are connecting to the MSSQL2005 ?

rt
User

Senior Boarder

Posts: 24

Karma: 0

Re:MSSQL Invalid cursor state

Posted: 2008/03/13 06:12

Diman wrote:
1) Do you have explicit transaction control in your application ?
2) Do you have SQL Native Client installed on workstation, when you are connecting to the MSSQL2005 ?

1, I haven't explicit transaction control.
2, Yes, I have SQL Native client installed on my workstation.

Thanks RT

Diman

Admin

Posts: 1461

Karma: 18

Re:MSSQL Invalid cursor state

Posted: 2008/03/13 07:25

I will appreciate, if you will send me the trivial test application, showing your issue.

rt
User

Senior Boarder

Posts: 24

Karma: 0

Re:MSSQL Invalid cursor state

Posted: 2008/03/13 07:39

Thx Diman!

Don't waste time with my problem. I try to resolve it , but if i will not successful i will send you a test application.

Regards RT

rt
User

Senior Boarder

Posts: 24

Karma: 0

Re:MSSQL Invalid cursor state

Posted: 2008/03/14 02:15

Hi Diman!

I'm working on this problem. This situation is very strange. I reistalled the sql server 2005, and attached to that 3 database with the same structure with data 2006,2007 and 2008). This problem is not present with the 2006 and 2007 database but present with 2008 database. The databases looks like fully same. So
I attached the Microsoft sample database called AdventureWorks and create a simple application with one query "select * from sysobjects" and the error is the same: "invalid cursor state". I can't figure out what's the difference between this databases. I don't belive that the microsoft sample database is corrupted too.

Regards RT

Diman

Admin

Posts: 1461

Karma: 18

Re:MSSQL Invalid cursor state

Posted: 2008/03/14 09:09

Sorry, but nothing is attached.

Forum List » AnyDAC » v 1.x General English