Last post Jul 04, 2014 10:53 AM by Lannie
Jun 30, 2014 10:05 AM|niranjan479|LINK
I have VS 2012 installed on my local machine running on windows 7 operating system.And I have oracle client installed on a server..I have access to the server network.So I want to connect to that database using web forms and retrieve the data into a gridview.Is
it possible? If so please let me know the code and the procedure.
Thanks, Niranjan Reddy
Jun 30, 2014 10:18 AM|mgebhard|LINK
Oracle Provider for .NET and read the documentation
Jun 30, 2014 10:28 AM|rajesh93180|LINK
You can call an oracle proc in ASP.Net this way..
OracleConnection oConn = new OracleConnection(ConfigurationManager.ConnectionStrings["oracleConnString"].ConnectionString);
OracleCommand oCmd = new OracleCommand("PKG_ER_SEL.sp_ERGetData", oConn);
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.Parameters.Add("v_param1", OracleDbType.Int32).Value = "1234";
oCmd.Parameters.Add("v_param2", OracleDbType.Int32).Value = "India";
oCmd.Parameters.Add("cv_1", OracleDbType.RefCursor, DBNull.Value, ParameterDirection.Output);
Oracle.DataAccess.Client.OracleDataAdapter da = new OracleDataAdapter();
DataSet ds = new DataSet();
ds = new DataSet("Checklist");
da.SelectCommand = oCmd;
catch (Exception ex)
Jul 04, 2014 05:22 AM|wmec|LINK
Jul 04, 2014 10:53 AM|Lannie|LINK
WIndows 7 development workstation
Install VS 2012 and Install Oracle Data Provider for Oracle 12c using the CLIENT install option, which will install the Oracle client locally on your development workstation.
(with this provider version can you communicate with Oracle 12c, 11g, and 10g databases and the latest Oracle Provider ensures best compatibility with VS 2012)
Optionally, you can have IIS enabled on the development workstation.
You can then test your web forms application from VS2012 and/or IIS if you enable that on Windows 7.
Then you can move your developed web site to a IIS ASP.NET Web Server in the network.
That Web Server will also need the Oracle Data Provider with CLIENT Option installed... exactly the same version.
You may have to make arrangements to allow traffic over the Oracle listening port so that your development platform and the web site host platform can communicate with Oracle database Server.
In a small office environment, the Web Server and Oracle Database Server can be on the same machine.
There is a bit of a learning curve to understand how to set up and use Oracle Data Provider and integrate into your server network situation and web site application.
References for the data provider are found here
I found this Oracle Press book quite helpful
To add a bit to complexity, the Oracle Data Provider is now produced as a UNMANAGED DRIVER (legacy) and the new MANAGED DRIVER (first attemp to put the client IN the data provider dll). The new managed driver works, but they are still adding functions and
fixing bugs, and I found in some SECURITY LOCKED DOWN environments, I have been unable to yet get it working properly. It is not hard to migrate the web application back and forth between UNMANAGED and MANAGED driver setups (just few changes in code like
Then there is the issue for UNMANAGED driver of putting the OracleDataAccess.dll in the GAC or not. Of couse, when you install the unmanaged driver it is put in the GAC. But I have found putting a copy of OracleDataAccess.dll in my application /BIN folder
and making a LOCAL reference to it, avoiding the GAC completely, works best for me moving my application from development, test, and production platforms.