.NETGURU
  Search:  
NamespacesDiscussions.NET v1.1Dot Net Guru's BlogIT Certification
Problem with Oracle Data Provider
Messages   Related Types
This message was discovered on ASPFriends.com 'ngfx-oracle' list.


Valmir M Meneses
Hi There,
I have installed .NET Oracle Data Provider beta 1 in a server with .NET =
framework and Oracle 8i.
As I compile my ASPX file an error reports that it can not instantiate the =
OracleConnection Object.
I have the < Import namespace=3D"System.Data.OracleClient"> before the =
line. I have already tried the full reference=20
Dim Con as System.Data.OracleClient.OracleConnection=20
and the error still remains.
Any clues?
Thanks,
Reply to this message...
 
    
Moua, Xay
You need to set it as a reference. Importing will only allow you to use it
without a lot of typing.

-----Original Message-----
From: Valmir M Meneses [mailto:Click here to reveal e-mail address]
Sent: Friday, May 24, 2002 9:31 AM
To: ngfx-oracle
Subject: [ngfx-oracle] Problem with Oracle Data Provider

Hi There,
I have installed .NET Oracle Data Provider beta 1 in a server with .NET
framework and Oracle 8i.
As I compile my ASPX file an error reports that it can not instantiate the
OracleConnection Object.
I have the < Import namespace="System.Data.OracleClient"> before the line. I
have already tried the full reference
Dim Con as System.Data.OracleClient.OracleConnection
and the error still remains.
Any clues?
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...
 
    
Moore, Dot Net Guruhew
And where did you get this provider? I've wanted to play with it!!

Dot Net Guru

-----Original Message-----
From: Valmir M Meneses [mailto:Click here to reveal e-mail address]
Sent: Friday, May 24, 2002 9:31 AM
To: ngfx-oracle
Subject: [ngfx-oracle] Problem with Oracle Data Provider

Hi There,
I have installed .NET Oracle Data Provider beta 1 in a server with .NET framework and Oracle 8i.
As I compile my ASPX file an error reports that it can not instantiate the OracleConnection Object.
I have the < Import namespace="System.Data.OracleClient"> before the line. I have already tried the full reference
Dim Con as System.Data.OracleClient.OracleConnection
and the error still remains.
Any clues?
Thanks,
Reply to this message...
 
    
Leon P Ford

You can find the Oracle Data Provider at
http://www.microsoft.com/downloads/release.asp?ReleaseID=37805

I have used this data provider and I have found that some things don't work
the same as using the equivalent calls using the oledb version connected to
the same database.

Assuming you are connecting to an Oracle database on a Unix server, the key
to getting the oracle connection to work is you must have the oracle client
software installed on the local computer, with the necessary service names
defined (I am connecting to an oracle 8.0.6 database)

This is the way I use it with success to get data from a select statement:

Dim cnn As New OracleConnection()
Dim cmd As New OracleCommand()
Dim dreader As OracleDataReader

dim strConnectionString = "Server=<your oracle service name>;" & _
"Integrated Security=false;" & _
"User ID=<your db user id>;" & _
"Password=<your db user password>;"
cnn.ConnectionString = <connection string data goes here>
cmd.Connection = cnn
cmd.CommandText = "select <selection list here> from <table name here>
where <criteria here>"

'
---------------------------------------------------------------------------
' Open the database and execute the command to put the data into the
data
' reader. This returns a single row of data.
'
---------------------------------------------------------------------------

cnn.Open()
dreader = cmd.ExecuteReader(CommandBehavior.SingleRow)
If dreader.Read() Then
<your code here to reference the columns of the datareader using
dreader("column name") syntax>
End If

'
---------------------------------------------------------------------------
' Close the datareader and database connection.
'
---------------------------------------------------------------------------

dreader.Close()
cnn.Close()

"Moore, Dot Net Guruhew"
<Click here to reveal e-mail address To: "ngfx-oracle" <Click here to reveal e-mail address>
.navy.mil> cc:
Subject: [ngfx-oracle] RE: Problem with Oracle Data Provider
05/24/2002 12:39
Please respond
to "ngfx-oracle"

And where did you get this provider? I've wanted to play with it!!

Dot Net Guru

-----Original Message-----
From: Valmir M Meneses [mailto:Click here to reveal e-mail address]
Sent: Friday, May 24, 2002 9:31 AM
To: ngfx-oracle
Subject: [ngfx-oracle] Problem with Oracle Data Provider

Hi There,
I have installed .NET Oracle Data Provider beta 1 in a server with .NET
framework and Oracle 8i.
As I compile my ASPX file an error reports that it can not instantiate the
OracleConnection Object.
I have the < Import namespace="System.Data.OracleClient"> before the line.
I have already tried the full reference
Dim Con as System.Data.OracleClient.OracleConnection
and the error still remains.
Any clues?
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.CommandBehavior
System.Data.OracleClient.OracleCommand
System.Data.OracleClient.OracleConnection
System.Data.OracleClient.OracleDataReader




ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
Ad


Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews
.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT
Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project
FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.
Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials
 
ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
 Copyright © ExamGuru, Inc. 2001-2006
Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification