Failed to retrieve data from the database. Details Database Vendor Code 210074 when Attempting to Run Crystal Report from FIMS

When running a custom Crystal report, the error "Failed to retrieve data from the database. Details: [Database Vendor Code: -210074]." can occur.
To troubleshoot error complete the following:

1. Unzip the attached ODBC test file in a directory on the machine you want to test. navigate to it and double click on ODBCTE32.
2. From the top menu, select Conn and select Full Connect. In the resulting window, select the Foundsql ODBC datasource and use sysprogress as the userid and password. Press OK.
3. In top part of window, type "select * from pub.profile" (do not type the quotes)and press the button with an exclamation point at the top. You should see a message in the bottom window that says something like this

SQLExecDirect:
In: hstmt = 0x019EE568, szSqlStr = "select * from pub.profile",
cbSqlStr = -3
Return: SQL_SUCCESS=0

4. Press the button next to the exclamation point that looks like a notepad. You should see profile data scroll through the bottom window.


If this works and is successful, then the problem is in the Crystal Report as the ODBC connection is working correctly. If the report was created by Blackbaud we will work with development on the report. We will need a copy of the report sent to us in order to submit to development. If the report was not created by Blackbaud, you will need to reach out to the developer who created the report for you.
odbctest.zip

Steps to Duplicate

1. Go to Custom and select the Crystal report to run
2. Enter in any needed parameters such as date range, etc.
3. See error occur.
 

Environment

 FIMS

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.