SQL Reporting Services and Sybase - String to Varchar

[guytz72]

Hi,

I am having an issue with a Report in SRS against a Sybase db.

The dataset for the report is a Sybase stored proc which is passed a parameter (varchar). When I run the proc in Sybase it runs fine, when I run it in SRS in the data tab it runs fine, but when I try to preview the report, or run from IE after deploying it I get the following error:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Query execution failed for data set 'Table_1'. (rsErrorExecutingCommand) Get Online Help
The given type name was unrecognized

Looks like it is an error converting the string in SRS to a varchar in Sybase, but I don't know how to fix it.

If I create a table with an identity (int) column and the varchar column, join this to the proc and pass the int as the parameter the report works fine!! (This is not an option in production though.)

I am using SybaseASE OLE DB Provider Version 02.70.0032

Any ideas?

TIA,
Guytz