MBR IT/.NET 247 : odp.net error!? on ASPFriends.com 'ngfx-oracle' list

odp.net error!?

Messages

Related Types

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

Valmir Meneses

Hi Guys,
I need some help.
I have been in this list and perhaps for my early stage in .NET, I have not
understood the hints an tips directed to my issue.
My code is:

<%@ Import Namespace="System.Data.OracleClient" %>

<script language="VB" runat="server" Debug="true">

Sub Page_Load(Sender As Object, E As EventArgs)

Dim con As New OracleConnection("SERVER=aspnet;USER ID=system;PWD=manager")
Dim cmd As New OracleCommand

con.Open()
cmd = New OracleCommand("select * from categories;",con)

DataGrid1.DataSource = cmd.ExecuteReader()
DataGrid1.DataBind()

End Sub

</script>

<asp:DataGrid id="DataGrid1" runat="server"/>

And I get this error:

Compiler Error Message: BC30002: Type 'OracleConnection' is not defined.

Source Error:

Line 5: Sub Page_Load(Sender As Object, E As EventArgs)
Line 6:
Line 7: Dim con As New OracleConnection("SERVER=aspnet;USER
ID=system;PWD=manager")
Line 8: Dim cmd As New OracleCommand
Line 9:

The Oracle Client has been installed and tested!
The ODP.NET has also been installed and updated.

Thanks,

Reply to this message...

Sreedhar Koganti

<html><div style='background-color:'><DIV>
<P>OracleClient might not reffered I guess. Go to references, from there select OracleClient in VisualStudio.Net explicitly. Then it should work.<BR><BR>Sreedhar<BR><A href="http://www.w3coder.com"" target="_blank">http://www.w3coder.com";>http://www.w3coder.com</A></P>
<P> </P>
<P><BR><BR> </P></DIV>
<DIV></DIV>
<DIV></DIV>>From: Valmir Meneses <Click here to reveal e-mail address>
<DIV></DIV>>Reply-To: "ngfx-oracle" <Click here to reveal e-mail address>
<DIV></DIV>>To: "ngfx-oracle" <Click here to reveal e-mail address>
<DIV></DIV>>Subject: [ngfx-oracle] odp.net error!?
<DIV></DIV>>Date: Fri, 21 Jun 2002 16:47:43 +0100
<DIV></DIV>>
<DIV></DIV>>Hi Guys,
<DIV></DIV>>I need some help.
<DIV></DIV>>I have been in this list and perhaps for my early stage in .NET, I have not
<DIV></DIV>>understood the hints an tips directed to my issue.
<DIV></DIV>>My code is:
<DIV></DIV>>
<DIV></DIV>><%@ Import Namespace="System.Data.OracleClient" %>
<DIV></DIV>>
<DIV></DIV>>
<SCRIPT language=VB Debug="true" runat="server">
</DIV>>
</DIV>> Sub Page_Load(Sender As Object, E As EventArgs)
</DIV>>
</DIV>> Dim con As New OracleConnection("SERVER=aspnet;USER ID=system;PWD=manager")
</DIV>> Dim cmd As New OracleCommand
</DIV>>
</DIV>> con.Open()
</DIV>> cmd = New OracleCommand("select * from categories;",con)
</DIV>>
</DIV>> DataGrid1.DataSource = cmd.ExecuteReader()
</DIV>> DataGrid1.DataBind()
</DIV>>
</DIV>> End Sub
</DIV>>
</DIV>></SCRIPT>

<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>><?xml:namespace prefix = asp /><asp:DataGrid id=DataGrid1 runat="server"></asp:DataGrid>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>And I get this error:
<DIV></DIV>>
<DIV></DIV>>Compiler Error Message: BC30002: Type 'OracleConnection' is not defined.
<DIV></DIV>>
<DIV></DIV>>Source Error:
<DIV></DIV>>
<DIV></DIV>>Line 5: Sub Page_Load(Sender As Object, E As EventArgs)
<DIV></DIV>>Line 6:
<DIV></DIV>>Line 7: Dim con As New OracleConnection("SERVER=aspnet;USER
<DIV></DIV>>ID=system;PWD=manager")
<DIV></DIV>>Line 8: Dim cmd As New OracleCommand
<DIV></DIV>>Line 9:
<DIV></DIV>>
<DIV></DIV>>The Oracle Client has been installed and tested!
<DIV></DIV>>The ODP.NET has also been installed and updated.
<DIV></DIV>>
<DIV></DIV>>Thanks,
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>| [ngfx-oracle] member Click here to reveal e-mail address = YOUR ID
<DIV></DIV>>| http://www.aspfriends.com/aspfriends/ngfx-oracle.asp = JOIN/QUIT
<DIV></DIV></div><br clear=all><hr>Get your FREE download of MSN Explorer at <a href='http://g.msn.com/1HM503401/37'>http://explorer.msn.com</a>.<br></html>

Reply to this message...

	System.Data.OracleClient.OracleCommand
	System.Data.OracleClient.OracleConnection
	System.EventArgs
	System.Web.UI.WebControls.DataGrid
	System.Windows.Forms.DataGrid

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