Hi,

I need to connect one of my application on Sharepoint to Oracle. I tried to do this by defining Custom String. But still it is not working.

Can anyone please tell me how to do this. It is very urgent and my whole project is based on this.

Please help me out!


Thanks,
Neetu

I'm not sure where your problem lies nor what a 'Custom String' is. You should be able to connect to any database supported by ADO.NET. You need to store the connection string and use the right ADO classes for Oracle, should be no different than connecting from a normal ASP.NET site.
Can you show how you are trying to do this?

__________________
--

Joe

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.


Thanks,
Neetu