By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,592 Members | 1,931 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,592 IT Pros & Developers. It's quick & easy.

Oracle connector

P: n/a
I want to get a connection to a Oracle database in myPage.aspx
I used the VS control and the wizard report succesfull connecting test.

The connection is defined
Conn1 As System.Data.OleDb.OleDbConnection

the connectionString property is
Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User
ID=user;Password=pass; Data Source=dbInst_IP;Extended Properties=""

when I need to get some data from database context is like this

Private Sub btnSeek_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnSeek.Click
If Conn1.State <> ConnectionState.Open Then
Conn1.Open()
End If

OleDbDataAdapter1.Fill(DataSet11)
txtNrInreg.Text = DataSet11.Tables(0).Rows(0).Item(0)
End Sub

At runtime the application stop at line
Conn1.Open()
with error
System.Data.OleDb.OleDbException: No error information available:
REGDB_E_CLASSNOTREG(0x80040154).
Any ideeas?, please!!

Nicolae Braduceanu


Apr 12 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
> I want to get a connection to a Oracle database in myPage.aspx
I used the VS control and the wizard report succesfull connecting test.

The connection is defined
Conn1 As System.Data.OleDb.OleDbConnection

the connectionString property is
Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User
ID=user;Password=pass; Data Source=dbInst_IP;Extended Properties=""

when I need to get some data from database context is like this

Private Sub btnSeek_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnSeek.Click
If Conn1.State <> ConnectionState.Open Then
Conn1.Open()
End If

OleDbDataAdapter1.Fill(DataSet11)
txtNrInreg.Text = DataSet11.Tables(0).Rows(0).Item(0)
End Sub

At runtime the application stop at line
Conn1.Open()
with error
System.Data.OleDb.OleDbException: No error information available:
REGDB_E_CLASSNOTREG(0x80040154).
Any ideeas?, please!!

Nicolae Braduceanu


a) there is also System.Data.OracleClient with classes specifically for
Oracle. You might need an extra reference to the assembly to be able to
access that namespace.

b) the classes in that OracleClient namespace need a local Oracle
client installation (including a correct tnsnames.ora), maybe that's
also the case for the OleDb classes?

Hans Kesting
Apr 12 '06 #2

P: n/a
Sorry,
I forgot to tell you that I'm using VS 2002 version.
I couldn't find in it a reference to System.Data.OracleClient to add in
Project->Add Reference... section.
Oracle Client is already installed on this computer.

The funny thing is that I put on my aspx page an OleDBDataAdapter and test
it with Preview Data tool.
I get the correct data in that form.
Nicolae Braduceanu

"Hans Kesting" <ne***********@spamgourmet.com> wrote in message
news:mn***********************@spamgourmet.com...
I want to get a connection to a Oracle database in myPage.aspx
I used the VS control and the wizard report succesfull connecting test.

The connection is defined
Conn1 As System.Data.OleDb.OleDbConnection

the connectionString property is
Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User
ID=user;Password=pass; Data Source=dbInst_IP;Extended Properties=""

when I need to get some data from database context is like this

Private Sub btnSeek_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnSeek.Click
If Conn1.State <> ConnectionState.Open Then
Conn1.Open()
End If

OleDbDataAdapter1.Fill(DataSet11)
txtNrInreg.Text = DataSet11.Tables(0).Rows(0).Item(0)
End Sub

At runtime the application stop at line
Conn1.Open()
with error
System.Data.OleDb.OleDbException: No error information available:
REGDB_E_CLASSNOTREG(0x80040154).
Any ideeas?, please!!

Nicolae Braduceanu


a) there is also System.Data.OracleClient with classes specifically for
Oracle. You might need an extra reference to the assembly to be able to
access that namespace.

b) the classes in that OracleClient namespace need a local Oracle client
installation (including a correct tnsnames.ora), maybe that's also the
case for the OleDb classes?

Hans Kesting

Apr 12 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.