DevOps, CI/CD and Automation

Dear All,

Since I could not able to use OleDb namespace to connect
Oracle when there exists Multiple Oracle Home in a
Production Server, Ive downloaded OracleClient, i.e. Data
Provider for Oracle Beta 1. But, it works in a 2000 Server
which has multiple Oracle Home. But, in another 2000 Server,
where there is only one Oracle Home, it gives the
following error.

Im using thru C# in asp.net.

Yours,
Sankar.B


Server Error in '/db' Application.
-----------------------------------------------------------
---------------------

Unable to find an entry point named OCIEnvCreate in DLL
oci.dll.
Description: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and where
it originated in the code.

Exception Details: System.EntryPointNotFoundException:
Unable to find an entry point named OCIEnvCreate in DLL
oci.dll.

Source Error:


Line 32:
Line 33: DataSet ds = new DataSet();
Line 34: myCommand.Fill(ds, "Authors");
Line 35:
Line 36: MyDataGrid.DataSource=ds.Tables
["Authors"].DefaultView;


Source File: D:\asp.net\dbcon\oracle_client_sample.aspx
Line: 34

Stack Trace:


[EntryPointNotFoundException: Unable to find an entry
point named OCIEnvCreate in DLL oci.dll.]
System.Data.OracleClient.DBObjectPool.GetObject
(Boolean& isInTransaction) +469

System.Data.OracleClient.OracleConnectionPoolManager.GetPoo
ledConnection(String encryptedConnectionString,
OracleConnectionString options, Boolean& isInTransaction)
+201
System.Data.OracleClient.OracleConnection.Open() +883
System.Data.Common.DbDataAdapter.QuietOpen
(IDbConnection connection, ConnectionState& originalState)
+44
System.Data.Common.DbDataAdapter.Fill(Object data,
Int32 startRecord, Int32 maxRecords, String srcTable,
IDbCommand command, CommandBehavior behavior) +98
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet,
Int32 startRecord, Int32 maxRecords, String srcTable,
IDbCommand command, CommandBehavior behavior) +77
System.Data.OracleClient.OracleDataAdapter.Fill(DataSet
dataSet, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) +29
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet,
String srcTable) +36
ASP.oracle_client_sample_aspx.Page_Load(Object sender,
EventArgs e) in
D:\asp.net\dbcon\oracle_client_sample.aspx:34
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.MobileControls.MobilePage.OnLoad
(EventArgs e) +135
System.Web.UI.Control.LoadRecursive() +29
System.Web.UI.Page.ProcessRequestMain() +724

-----------------------------------------------------------
---------------------
Version Information: Microsoft .NET Framework
Version:1.0.3705.209; ASP.NET Version:1.0.3705.0