Problems connecting from reporting services to Oracle using odbc connection and asp.net 2.0

Hi,

Anybody have a clear idea why I might have problems connecting from reporting services to Oracle 9i database using the Microsoft ODBC driver? Getting following error

"Cannot create a connection to data source 'oracleName'.

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

"

I have the data source correctly set-up thought. Is it a permissions problem?

Thanks.

When you say you have it set up correctly, do you mean that you were able to connect to it from other applications? or what exactly?

Assuming it is correct, try using the Microsoft OLE DB Provider for ODBC. This always works for me.

>L<