ASP.net page can't find namespace system.data.orac

mel · April 14th, 2004, 12:08 PM

Hi
I have an Oracle database to connect to. If I write the code in a class and compile it with vbc and then reference my namespace in the asp.net page it connects up to the database. If I just write call the code in an asp.net page and import the system.data.OracleClient, the page throws up an error saying it can't find the namespace
Can anyone help

Mel

stu9820 · April 14th, 2004, 12:55 PM

Did you install the OracleClient?

mel · April 15th, 2004, 02:22 AM

If the code is all contained as an assembley (ie a dll, compiled using the vbc command line tool) everything is ok. The Oracle client software is on the web server machine. It seems to have a problem referencing the Namespace if the code is all in an asp.net web page

planoie · April 16th, 2004, 11:06 AM

Can you post just the relevant bits of code for this problem? Like the class declaration for the page and the import statements? We don't need all the guts of your page or the data access code, just the parts that relate directly to this problem.

I'm a little confused by your first post:
A) Is your custom class code consuming system.data.OracleClient classes and failing?
B) Is the ASP.net page trying to consume system.data.OracleClient classes and failing?
C) Is the ASP.net page trying to consume your custom class and failing?

Peter
-------------------------
Work smarter, not harder

mel · April 19th, 2004, 03:18 AM

Hi
Just by including <%@ Import Namespace="System.Data.OracleClient" %> in an aspx web page causes the following error BC30466: Namespace or type 'OracleClient' for the Imports 'System.Data.OracleClient' cannot be found.

Line 19: Imports System.Data.OracleClient

jasonburrwc84 · December 2nd, 2004, 05:17 PM

I'm having the same problem. I have installed the ODBC drivers and have installed ODP.net. There is a reference made in my project to Oracle.DataAccess.dll yet I still get the same message.

error BC30466: Namespace or type 'OracleClient' for the Imports 'System.Data.OracleClient' cannot be found.

Here is my code that just trys to make a simple connection to the database:

<%@ Page Language="vb" AutoEventWireup="false" Codebehind="OleDbConnection.aspx.vb" Inherits="tryagain.OleDbConnection"%>
<%@ Import NameSpace="System.Data.OracleClient"%>

<Script runat="server">
Sub Page_Load( s As Object, e As EventArgs )
    Dim conOracle As OracleConnection

    conOracle = New OracleConnection("Data Source=trng;User Id=burrjh;Password=melissa84;")
    conOracle.Open()
    conOracle.Close()
End Sub

</Script>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
    <HEAD>
        <title>OracleDbConnection</title>
        <Script runat="server">

        </Script>
        <meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
        <meta name="CODE_LANGUAGE" content="Visual Basic .NET 7.1">
        <meta name="vs_defaultClientScript" content="JavaScript">
        <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
    </HEAD>
    <body MS_POSITIONING="GridLayout">
        Connection Opened!
        <form id="Form1" method="post" runat="server">
        </form>
    </body>
</HTML>

Thanks,

Jason

jasonburrwc84 · December 2nd, 2004, 05:24 PM

Just found the answer that worked for me.

I had the same error msg after installing this driver.
I added ref to project and registered System.Data.OracleClient.dll with gacutil but error continued.
When I copied the dll to the project bin directory, it was able to use the driver. It also continues to use it now that I have deleted the dll from the project bin.
A bit of a mystery to me but it seems to work.

hope this helps