Last post Feb 10, 2012 10:08 PM by necro_mancer
Feb 10, 2012 08:13 AM|tracmonali|LINK
I have created a crystal report which works fine locally. However, when I put it on prod server, it gives me following error:
Failed to retrieve data from the database. Details: [vendor defined code 229]
I have rechked my OLE db connections and they are fine. They work locally but not on server. any help appreciated
Feb 10, 2012 08:31 AM|surjeet_kumar1|LINK
229 is a security error. The account used to make the connection does not have access
to either the view or one of the tables in the view. Talk to your admin and have him/her
check the account's permissions.
Feb 10, 2012 10:08 PM|necro_mancer|LINK
It is quite normal if you are experiencing issues when deploying Crystal Report on a server. Based on the error message you experienced, it seems that you have not properly setup/configured your Crystal Report on the PC/server:
1. You must make sure the crystal report installed on the server matches the crystal report version used on your code.
2. Once you have the CR installed on your system, please make sure you set your Crystal Report to operate on LOCAL SERVICE permission. Please check your application pool and make sure it runs under this permission
3. Please make sure the FULL TRUST read and write permission is set on your working folder
4. Please make sure you copy the CR aspnet_client folder to your working folder
Once you have done all the steps above, your crystal report 2010 should work fine. If you are still experiencing problems with your host, I would truly recommend you to migrate your service to asphostcentral.com.
This host has supported Crystal Report for VS 2010 and any earlier Crystal Report version.
If this post helps you, please mark it as an answer. Good luck!
P.S: Please always make sure you have one Crystal Report version running on your own server. If you have multiple different CR version, your report will not work!