Skip to Content

Database Connector Error in business object when call the crystal report

Nov 02, 2017 at 06:08 AM


avatar image
Former Member

The stored procedure is successful

The report call the stored procedure is successfully, crystal report version is 14.0

Unfortunately it failed when run the report in business object with Database connector error: 42000 ODBC SQL Server Driver Error converting data type to date.

In the stored procedure I already set the dateformat DMY, and default date format in crystal report is also DMY.


10 |10000 characters needed characters left characters exceeded


We will need more details to help with this question.

Can you provide the code for stored procedure, or a trimmed-down version that reproduces the problem?

What is the output from the procedure?

Do you know which output variable is causing the error?


Mike Loop
Senior Support Engineer
SAP Product Support

* Please Login or Register to Answer, Follow or Comment.

0 Answers