tscottt
asked on
Oracle dataaccess client from asp pages without Visual Studio .NET
I have created a web.config file with an explicit reference to the oracle data access client.
Yet the code will not compile at runtime.
I don't want to buy and install Visual Studio .NET just so I can tell the run-time compiler to include a reference to the oracle.dataaccess.dll
But I can't seem to get the namespace (and associate object) loaded.
Yet the code will not compile at runtime.
I don't want to buy and install Visual Studio .NET just so I can tell the run-time compiler to include a reference to the oracle.dataaccess.dll
But I can't seem to get the namespace (and associate object) loaded.
<oracle.dataaccess.client>
<settings>
<add name="DllPath" value="C:\oracle\bin"/>
<add name="FetchSize" value="65536"/>
<add name="PromotableTransaction" value="promotable"/>
<add name="StatementCacheSize" value="10"/>
<add name="TraceFileName" value="C:\odpnet2.trc"/>
<add name="TraceLevel" value="0"/>
<add name="TraceOption" value="0"/>
</settings>
</oracle.dataaccess.client>
</configuration>
---------------------------
Yet when I try to use an ASPX page that references the oracle.dataaccess.client namespace, I get:
Compiler Error Message: CS0246: The type or namespace name 'Oracle' could not be found (are you missing a using directive or an assembly reference?)
Source Error:
Line 1: <%@ Page Language="c#" %>
Line 2: <%@ import Namespace="System.Data" %>
Line 3: <%@ import Namespace="Oracle.DataAccess.Client" %>
Line 4: <%@ import Namespace="System.Data.OleDb" %>
Line 5: <script runat="server">
--------------
Microsoft (R) Visual C# 2005 Compiler version 8.00.50727.3053
for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727
Copyright (C) Microsoft Corporation 2001-2005. All rights reserved.
c:\myWeb\CursorTest2.aspx(3,11): error CS0246: The type or namespace name 'Oracle' could not be found (are you missing a using directive or an assembly reference?)
ASKER
Thank you tculler, this seems close to the solution I need. But how to I add a compiler switch without using Visual Studio and telling it to add a reference? Is there a configuration file somewhere that keeps track of compiler diriectives or references?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
/reference:System.Data.Ora
Or, if that's not the correct DLL, just replace System.Data.OracleClient.d