Failed to retrieve data from the database, Database Vendor Code 9421

Question

I  have a report made in Crystal Reports XI. The report is generated and exported to PDF in visual basic script using COM interface. Generally everything is running smoothly, but in one case generation breaks with error:

Failed to retrieve data from the database. Details: [Database Vendor Code 9421]

Database used is MSSQL 2005 connected over ODBC to CR XI. When I am opening report with exactly the same parameters in Designer, everything works fine.

It looks like it is data related, but it is hard to trace since the whole report is pretty sophisticated. Anyway I spent half a day on crawling over Dr. Google and it seems that he has no clue what might be an issue.

---

Best regards, Rafal Ziolkowski http://ziuek.blogspot.com

Answer 1

Hello

Follow this steps

1)     Verify the database.

2)     Make sure your report’s formula does not contain any errors.

 

Mark as answer if it’s useful.

Free Source Code

Answer 2

Make sure you have permission to the tables that you are using

 

if you are using a user  other than the dba make sure they have permission to the tables

if you have done a special sql query reset the sql and try it without the custom query.