I am getting an ODBC error when I use a SQL Server 2000 Stored procedure as my data source. The error Msg is: ODBC error; [Microsoft][ODBC SQL Driver] Invalid character value for cast specification.
I can run the stored procedure in the query analyzer and I get data returned without any errors reported. I examined my data and found no anomalies. Also I removed all Cast conversions from the SQL and replaced with convert. I still get the same error message.
The ODBC driver version is SQL Server 2000.85.1117.00