MBR IT/.NET 247 : .NET Oracle Data Provider beta 1 on ASPFriends.com 'ngfx-oracle' list

.NET Oracle Data Provider beta 1

Messages

Related Types

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

Valmir M Meneses

Ok ASPFRIENDS,
I have downloaded and sucessfully installed The .NET Oracle Data Provider =
beta 1.
I have tried to use the recommended Oracle Connection NameSpace, but It is =
not recognized!
Here follows the code:

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

<script language=3D"VB" runat=3D"server">

Sub Page_Load(Sender As Object, E As EventArgs)
=20
Dim con As New OracleConnection("SERVER=3D;USER ID=3DASPNET;PWD=3Daspne=
t")
Dim cmd As OracleCommand
=20
con.Open()
cmd =3D New OracleCommand("select * from categories;",con)
=20
DataGrid1.DataSource =3D cmd.ExecuteReader()
DataGrid1.DataBind()
=20
End Sub
=20
</script>

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

The compiler reports no acknowledgment of an OracleConnection object.
I have also tried=20
Dim con As New System.Data.OracleClient.OracleConnection("SERVER=3D;USER =
ID=3DASPNET;PWD=3Daspnet")

And the error persists...

Any help appreciated,
Thanks,

Reply to this message...

Moua, Xay

Where are you pointing your server to? It needs to point to a TNSNAMES
entry in you TNSNAME.ORA file. You also need to have the Oracle client
installed. Finally, you need to reference it in your solution. VS doesn't
know what you are trying to import if you don't reference it first.

-----Original Message-----
From: Valmir M Meneses [mailto:Click here to reveal e-mail address]
Sent: Tuesday, May 28, 2002 5:27 AM
To: ngfx-oracle
Subject: [ngfx-oracle] .NET Oracle Data Provider beta 1

Ok ASPFRIENDS,
I have downloaded and sucessfully installed The .NET Oracle Data Provider
beta 1.
I have tried to use the recommended Oracle Connection NameSpace, but It is
not recognized!
Here follows the code:

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

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

Sub Page_Load(Sender As Object, E As EventArgs)

Dim con As New OracleConnection("SERVER=;USER ID=ASPNET;PWD=aspnet")
Dim cmd As 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"/>

The compiler reports no acknowledgment of an OracleConnection object.
I have also tried
Dim con As New System.Data.OracleClient.OracleConnection("SERVER=;USER
ID=ASPNET;PWD=aspnet")

And the error persists...

Any help appreciated,
Thanks,

| [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...

Sreedhar Koganti

<html><div style='background-color:'><DIV>
<P>You have to explicitly refer this using References[Visual Studio.Net], Then it works. </P>
<P>>From: "Valmir M Meneses" <Click here to reveal e-mail address></P></DIV>
<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] .NET Oracle Data Provider beta 1
<DIV></DIV>>Date: Tue, 28 May 2002 10:26:34 +0100
<DIV></DIV>>
<DIV></DIV>>Ok ASPFRIENDS,
<DIV></DIV>>I have downloaded and sucessfully installed The .NET Oracle Data Provider beta 1.
<DIV></DIV>>I have tried to use the recommended Oracle Connection NameSpace, but It is not recognized!
<DIV></DIV>>Here follows the code:
<DIV></DIV>>
<DIV></DIV>><%@ Import Namespace="System.Data.OracleClient" %>
<DIV></DIV>>
<DIV></DIV>>
<SCRIPT language=VB runat="server">
</DIV>>
</DIV>> Sub Page_Load(Sender As Object, E As EventArgs)
</DIV>>
</DIV>> Dim con As New OracleConnection("SERVER=;USER ID=ASPNET;PWD=aspnet")
</DIV>> Dim cmd As 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>>The compiler reports no acknowledgment of an OracleConnection object.
<DIV></DIV>>I have also tried
<DIV></DIV>>Dim con As New System.Data.OracleClient.OracleConnection("SERVER=;USER ID=ASPNET;PWD=aspnet")
<DIV></DIV>>
<DIV></DIV>>And the error persists...
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>Any help appreciated,
<DIV></DIV>>Thanks,
<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>Send and receive Hotmail on your mobile device: <a href='http://g.msn.com/1HM303401/38'>Click Here</a><br></html>

Reply to this message...

Steven M. Swafford

Did you ever get this working? I had a similar issue and ended up using
oleDB, if so, can you provide an example?

-----Original Message-----
From: Valmir M Meneses [mailto:Click here to reveal e-mail address]
Sent: Tuesday, May 28, 2002 4:27 AM
To: ngfx-oracle
Subject: [ngfx-oracle] .NET Oracle Data Provider beta 1

Ok ASPFRIENDS,
I have downloaded and sucessfully installed The .NET Oracle Data
Provider beta 1.
I have tried to use the recommended Oracle Connection NameSpace, but It
is not recognized!
Here follows the code:

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

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

Sub Page_Load(Sender As Object, E As EventArgs)

Dim con As New OracleConnection("SERVER=;USER ID=ASPNET;PWD=aspnet")
Dim cmd As 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"/>

The compiler reports no acknowledgment of an OracleConnection object.
I have also tried
Dim con As New System.Data.OracleClient.OracleConnection("SERVER=;USER
ID=ASPNET;PWD=aspnet")

And the error persists...

Any help appreciated,
Thanks,

| [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...

	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