SharePoint Visual web part and Oracle connection problem

Question

I'm trying to build a "visual web part" for SharePoint 2010 which should connect to Oracle table and display records on SharePoint page.For development, Oracle 11g client (with ODP.net) ,SharePoint server 2010, Visual Studio 2010 and Oracle 10g express all running on my machine.

First,I've written sample code in ASP.NET web app to connect my local Oracle table and display data in grid view and it works fine. My code is ,

OracleConnection con;
            try
            {
                // Connect
                string constr = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)));User Id=SYSTEM; Password=password";

                con = new OracleConnection(constr);

                //Open database connection
                con.Open();

                // Execute a SQL SELECT
                OracleCommand cmd = new OracleCommand("select * from T_ACTIONPOINTS WHERE AP_STATUS='Active' ", con);
                OracleDataReader dr = cmd.ExecuteReader();

                GridView.DataSource = dr;

                GridView.DataBind();
                GridView.AllowPaging = true;

            }
            catch (Exception e)
            {
                lblError.Text = e.Message;
            }

Now, I'm trying to create new "SharePoint" visual web part project and using same code and deploying it on my local SP server. But when it runs , I get following error

enter image description here

here is my solution explorer,

enter image description here

It looks something wrong in compatibility.Can someone point me in right direction ?

Rich Bennema · Accepted Answer · 2011-02-01 15:23:38Z

0

In Visual Studio 2010, references are not always included in the solution package by default. So just because it is in the project references, does not necessarily mean it will make the trip to the server. To check if your DLL is in the solution package:

open Package from the Solution Explorer
click the Manifest tab

Do the following steps, if your DLL is not listed in the Assemblies section:

click the Advanced tab
under Additional Assemblies, click Add > Add Existing Assembly...
locate your DLL and click OK

answered Feb 1, 2011 at 15:23

Rich Bennema

10.3k4 gold badges40 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ris Over a year ago

Hey Rich,Thanks dll was not there and I've added it as you said. Still the same error.

Madhur Ahuja · Accepted Answer · 2011-02-01 09:03:04Z

0

Do you have Oracle.DataAccess.dll . You need to put it in bin directory of sharepoint web application.

Alternatively, you must be referring it in your web part as a reference. Make sure that this DLL is included in your solution package.

answered Feb 1, 2011 at 9:03

Madhur Ahuja

22.8k15 gold badges77 silver badges128 bronze badges

1 Comment

Ris Over a year ago

Thanks Madhur.I've referenced Oracle.dataaccess.dll to my SharePoint project. Along with that I've copied the dll in BIN folder , \web server extensions\14\BIN and \web server extensions\14\config\BIN Still no success.

Collectives™ on Stack Overflow

SharePoint Visual web part and Oracle connection problem

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related