ODBC error: Invalid parameter number.

[DianaStewart]

Has anyone ever come across this error message when trying to run a report:

Crystal Reports: Database Error
ODBC error: Invalid parameter number.


When I click the OK button I get Error Detected by database dll.

 

[DianaStewart]

I have two datasources: one is a ODBC and the other is a Access 2000 database. My parameter field is a Date data type but when I want to access a ceratin date field, the data type of this field is date\time.

 

[DianaStewart]

I am connecting to two backends. One backend is a ODBC data source and the second is a Access database on my local PC. When I run the report I get the error Invalid Parameter number. The only parameter fields I have are dates. In my odbc I am connecting to a date\time field and in the Access database the data shows as date only. I do not know if this is the cause or not?

I am using a Subreport (connects to Access database) and the ODBC connects on the Main report...