• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Crystal 10 problem after database upgrade


Hello list,
last week we upgraded our database from SQL 2000 to SQL 2005 including SNAC. Ever since, Crystal isnt working anymore. Whenever a report is run that uses multiple connections (get data from a file and run a 'sql command' to fetch other data, for instance UDC descriptions), crystal returns that 'connection is busy with results for another command'

I've been looking on google for something that might cause this and I think I need to enable MARS for my SNAC, but I cant find where I should do that in my ODBC connection.

Anyone else encountered this problem? Or knows how to solve it?