Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Invalid cursor state

Author  Topic 

dandare00uk
Starting Member

1 Post

Posted - 2011-04-12 : 05:52:12
Database Connection Error:'24000:[Microsoft][ODB SQL Server Driver]Invalid cursor state

Hi, we get this error from Crystal Reports when it tries to run a specific report. ODBC from the Citrix server to the SQL server works fine as does the only other Crystal Report we use.

To add to the confusion, if we copy the database to another server which should be identical to the first the Report works when pointed to this server.

Any ideas?
Colin.

tariq_erp
Starting Member

9 Posts

Posted - 2013-09-04 : 01:11:46
Possibly there`s a mismatch in parameter order of report and sql procedure.

Tariq Aziz.
Go to Top of Page
   

- Advertisement -