ORA-01858 Error when using querystring in SQL datasource...

[Mapper99]

If I execute this query in VS2008, data is returned OK:

SELECT DESCRIPTION
FROM AZTECA.REQUEST
WHERE (DATETIMEINIT > TO_DATE('09/03/2008', 'MM/DD/YYYY')) AND (DATETIMECLOSED < TO_DATE('09/04/2008', 'MM/DD/YYYY'))

If I execute the same query with a parameter:

SELECT DESCRIPTION
FROM AZTECA.REQUEST
WHERE (DATETIMEINIT > TO_DATE('09/03/2008', 'MM/DD/YYYY')) AND (DATETIMECLOSED < TO_DATE(:CLOSEDDATE, 'MM/DD/YYYY'))

and enter 09/04/2008 as the date, I get this error:

ORA-01858: a non-numeric character was found where a numeric was expected

Has anyone seen this one before?

Thanks in advance,

Mapper

[dickersonka]

What is this ? What is the colon by the way?

:CLOSEDDATE