MBR IT/.NET 247 : getting MS oracle .NET client to work on ASPFriends.com 'ngfx-oracle' list

getting MS oracle .NET client to work

Messages

Related Types

This message was discovered on ASPFriends.com 'ngfx-oracle' list.

Michael Gerholdt

I recently installed the MS Oracle Client.

I have Oracle's NET8 (sqlnet) installed and working with other clients.

When I attempt to use the Oracle client in asp.net page,

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

Code as follows:

<%@ Page Language="VB" %>
<%@ Register TagPrefix="wmx" Namespace="Microsoft.Saturn.Framework.Web.UI"
Assembly="Microsoft.Saturn.Framework, Version=0.5.464.0, Culture=neutral,
PublicKeyToken=6f763c9966660626" %>
<%@ import Namespace="System" %>
<%@ import Namespace="System.Text" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OracleClient" %>
<script runat="server">

sub Page_Load(sender as Object, e as EventArgs)

Dim connString as String
connString = "Data Source=Oracle8i;Integrated Security=yes"

Dim myConn as New OracleConnection(connString)

==================

Thanks for any clues as to what I might have wrong.

Mike

Reply to this message...

Leon P Ford

Did you add a reference to the dll to your project?
---
Regards,
Leon

|---------+--------------------------->
| | "Michael |
| | Gerholdt" |
| | <gerholdt@fredon|
| | ia.edu> |
| | |
| | 08/01/2002 13:27|
| | Please respond |
| | to "ngfx-oracle"|
| | |
|---------+--------------------------->
>--------------------------------------------------------------------------------------------------------------------------------|
| |
| To: "ngfx-oracle" <Click here to reveal e-mail address> |
| cc: |
| Subject: [ngfx-oracle] getting MS oracle .NET client to work |
>--------------------------------------------------------------------------------------------------------------------------------|

I recently installed the MS Oracle Client.

I have Oracle's NET8 (sqlnet) installed and working with other clients.

When I attempt to use the Oracle client in asp.net page,

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

Code as follows:

<%@ Page Language="VB" %>
<%@ Register TagPrefix="wmx" Namespace="Microsoft.Saturn.Framework.Web.UI"
Assembly="Microsoft.Saturn.Framework, Version=0.5.464.0, Culture=neutral,
PublicKeyToken=6f763c9966660626" %>
<%@ import Namespace="System" %>
<%@ import Namespace="System.Text" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OracleClient" %>
<script runat="server">

sub Page_Load(sender as Object, e as EventArgs)

Dim connString as String
connString = "Data Source=Oracle8i;Integrated Security=yes"

Dim myConn as New OracleConnection(connString)

==================

Thanks for any clues as to what I might have wrong.

Mike

| [ngfx-oracle] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-oracle.asp = JOIN/QUIT

Reply to this message...

Moua, Xay

Add it to your reference. Importing does not reference the DLL.

Xay

-----Original Message-----
From: Michael Gerholdt [mailto:Click here to reveal e-mail address]
Sent: Thursday, August 01, 2002 1:28 PM
To: ngfx-oracle
Subject: [ngfx-oracle] getting MS oracle .NET client to work

I recently installed the MS Oracle Client.

I have Oracle's NET8 (sqlnet) installed and working with other clients.

When I attempt to use the Oracle client in asp.net page,

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

Code as follows:

<%@ Page Language="VB" %>
<%@ Register TagPrefix="wmx" Namespace="Microsoft.Saturn.Framework.Web.UI"
Assembly="Microsoft.Saturn.Framework, Version=0.5.464.0, Culture=neutral,
PublicKeyToken=6f763c9966660626" %>
<%@ import Namespace="System" %>
<%@ import Namespace="System.Text" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OracleClient" %>
<script runat="server">

sub Page_Load(sender as Object, e as EventArgs)

Dim connString as String
connString = "Data Source=Oracle8i;Integrated Security=yes"

Dim myConn as New OracleConnection(connString)

==================

Thanks for any clues as to what I might have wrong.

Mike

| [ngfx-oracle] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-oracle.asp = JOIN/QUIT

Reply to this message...

Michael Gerholdt

I'm developing in ASP.NET Web Matrix rather than .NET Studio. In .NET Studio
I can see the dll listed as something I can reference, however.

Is there a way I can reference it using Matrix or do I need to instead do
this project in .NET?

Thanks,
Mike

[Original message clipped]

Reply to this message...

Moore, Matthew

Web Matrix won't allow you to add specific DLL files as refrences to the project? It shows up in my cache list if I go to add it as a reference and then I make sure I have the following lines at the top of the code.

using System.Data;
using System.Data.OracleClient;

If that doesn't work, just copy the .dll file to your bin directory of your project and see if that works. System.Data.OracleClient.dll should be the appropriate file.

Matt

-----Original Message-----
From: Michael Gerholdt [mailto:Click here to reveal e-mail address]
Sent: Friday, August 02, 2002 12:16 PM
To: ngfx-oracle
Subject: [ngfx-oracle] RE: getting MS oracle .NET client to work

I'm developing in ASP.NET Web Matrix rather than .NET Studio. In .NET Studio
I can see the dll listed as something I can reference, however.

Is there a way I can reference it using Matrix or do I need to instead do
this project in .NET?

Thanks,
Mike

[Original message clipped]

Reply to this message...

	System.Data.OracleClient.OracleConnection
	System.EventArgs

MBR BootFX
Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

	Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd.
	Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com