Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SharePoint > SharePoint Development
SharePoint Development Programming and development for SharePoint Portal Server and Windows SharePoint Services
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SharePoint Development section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old June 24th, 2009, 06:42 AM
Registered User
Join Date: Jun 2009
Posts: 2
Thanks: 1
Thanked 0 Times in 0 Posts
Default Sharepoint connectivity with Oracle


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!

Old June 24th, 2009, 07:25 AM
joefawcett's Avatar
Wrox Author
Join Date: Jun 2003
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts

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?
The Following User Says Thank You to joefawcett For This Useful Post:
neetu (June 29th, 2009)
Old June 29th, 2009, 06:57 AM
Registered User
Join Date: Jun 2009
Posts: 2
Thanks: 1
Thanked 0 Times in 0 Posts

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.


Similar Threads
Thread Thread Starter Forum Replies Last Post
[Microsoft] [ODBC driver for oracle] [oracle] ORA-06413: connection not open dpkbahuguna Beginning VB 6 7 May 5th, 2009 12:31 AM
Vb oracle connectivity error dpkbahuguna Beginning VB 6 0 May 2nd, 2009 08:01 AM
call oracle function using oracle link server vl SQL Server 2000 1 July 12th, 2007 08:19 AM
CR connectivity to Oracle DB CRuser Crystal Reports 0 June 21st, 2004 01:29 AM
ASP connectivity with ORACLE pkdev Classic ASP Databases 1 February 20th, 2004 04:13 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.