Connecting to Oracle database

Hi,

I want to connect to Oracle Database by creating a dsn in SQL Server 2005 Reporting Tool. I am unable to creating a new dsn with the wizard ir is providing, please help me how to create a new dsn so that my new report can get the data from Oracle database.

Thanks in Advance,

Ramesh.

You have to setup the oracle server with the ORACLE Net Provider which has to be installed first, for ORacle 8 its Oracle NET8. Then you can choose the provider in the DNS selector. Although there is a Provider within the .NET Framework I would perfer installing the Oracle provider.

HTH, Jens Suessmeyer.