Thanks a lot Joe to reply me so soon.
I am so sorry that I couldnt reply u back as there ws some problem in my family.
I did the following steps for connectivity:
a. In Data Source Library I tried to establish a new database connection.
c. Selected Provider as ‘Microsoft .net Framework Provider for SQL Server’
d. Specified the Connection String as
Provider=OraOLEDB.Oracle;OLEDB.NET=true;PLSQLRSet= true;Password=<<>>;User ID=<<>>;Data Source=<<>>
d. After defining the string I clicked Ok.
e. After click Next It gives the message “The selected authentication option saves the user name and password as clear text in the data connection. Other authors of this website can access this information.”
f. I clicked on Ok and it gives me the message “Server Error: An error occurred while retrieving the list of table from root database. The query you are trying to execute contains syntax errors.”
g. After this it displays list of database, but gives only ‘root’ as a database.
I dont know where I am lacking. Your support will really help me to come out from this hunt.