Skip to Content
0
Jun 12, 2019 at 12:51 PM

Invalid Argument provided. Failed to retrieve data from the database.

707 Views

Environment:

CR version: 13.0.16.1954, Visual Studio: 2015, SQL Server 2014 and the DSN used is: "Odbc driver 11 for SQL Server".

We are generating a crystal report from two tables and when we try to preview the report we see an error - "Invalid argument provided. Failed to retrieve data from the database. Error in file..... Invalid argument for database".

I've gone through the SAP question and answers and articles and nothing helped me. I've seen "https://blogs.sap.com/2011/09/29/fail-to-retrieve-data-from-the-database-when-printing-with-crystal-reports/" and this too didn't help in fixing.

Unfortunately, enabling 'LogonProperties' with "UseDSNProperties" to true fixed the issue. Enabling this property had many other side affects on other different reports.

Can anyone please help me in fixing this issue. Thank you.

Harish