Report Manager on 64 bit machine does not recognize 32 bit data sources

I'm a report developer who has created some reportsd against sybase data on another server. I am developing on a 64 bit Server 2003 box using SQL 2005 Reporting services. I hace created 32 bit ODBC data dsns using the supplied utitlity (odbcad32.exe). As I am creating the reports I can pull data using the data sources without a problem, however when I deploy my datasource and report to Report manager and run I get the following:

An error has occurred during report processing.

Cannot create a connection to data source 'Chicago_Reporting'.

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

This has been driving me crazy for 2 days now. Any help would be very much appreciated.

Thanks

Hi Rick!

I use a 64-bit Windows Server 2003 Enterprise server also and connect to about seven different database types, although Sybase is not one of them. Have you installed SQL Server 2005 Service Pack 2?

|||

HI Chuck,

Thanks for the response. I have limited experience with server admin stuff. I was brought for my reporting experience more then anything else. As far as I can tell our build number is 2005.090.3042.00 which equates to the original version of SP2 on the build list.

Rick