.NET connecting to Oracle 9i
.NET, .NET development, Oracle 9i, Oracle 9i Enterprise Edition 9.2.0.7.0, Oracle connectivity, Oracle development, Visual Studio 2003
Please Help.
I am new to .Net. Using .Net 2003 Oracle 9i
Imports Oracle.DataAccess.Client
Public Class Form1
Inherits System.Windows.Forms.Form
Dim objConnection As OracleConnection = New _
OracleConnection("User Id=system;Password=dax856;Data Source=DMS")
Dim objDataAdapter As New OracleDataAdapter
Dim objDataSet As DataSet = New DataSet
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
' Set the SelectCommand properties...
objDataAdapter.SelectCommand = New OracleCommand
objDataAdapter.SelectCommand.Connection = objConnection
objDataAdapter.SelectCommand.CommandText = _
"Select * From EMP"
objDataAdapter.SelectCommand.CommandType = CommandType.Text
' open the data base
objConnection.Open()
An unhandled exception of type 'Oracle.DataAccess.Client.OracleException' occurred in oracle.dataaccess.dll
Additional information: System error.
Imports System.Data
I am able to connect to the database using the Tool - Connect to Data Base
I am not able to connect to the database using the Tool - Connect To Oracle Data Base
Regards
Software/Hardware used:
Software/Hardware used:
ASKED:
March 8, 2009 12:57 AM
UPDATED:
March 9, 2009 4:14 PM
RELATED QUESTIONS
- What am I doing wrong. Please Help
- ASP.NET C# database connection in external file
- VB.NET - Can't insert data into database.
- VB.NET code to search if a record already exists or not
- I have code for search button which only access on table in databaseI want sql query which access All tables in database.Iam pasting following code
Answer Wiki:
Have you debugged your program ?
In what line of your code do you get the unhandled exception error ?
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
