ODBC error using Crystal report 8.5 and SQL server 2000

[psperry2]

The ODBC Driver version is SQL Server 2000.85.1117.00

I get this error when using a stored procedure as a data source for my crystal report.

ODBC error: [Microsoft][ODBC SQL Driver] Invalid character value for cast specification.

So I tried the following:

1) removed all the cast conversions in the stored procedure and replaced with convert. Still get this error
2) Ran the stored procedure in the Query analyzer and it runs without error and returns correct data.

 

[genomon]

Posted a response in the SQL Server forum - this is a duplicate post....

Always remember that you're unique. Just like everyone else.