Anyone could provide an example to connect to the oracle database? I keep having problem connecting.
http://devpinoy.org/blogs/cruizer
I am using System.Data.OracleClient.
My current code (just a simple test):
Dim cn As New OracleConnection("Data Source=servicename;User ID=username;Password=pwd;")
Try
Dim da As New OracleDataAdapter("select count(*) from Tablename", cn)
Dim dt As New DataTable
da.Fill(dt)
da.Dispose()
Me.DataGrid1.DataSource = dt
Me.DataGrid1.DataBind()
dt.Dispose()
Catch ex As Exception
Me.Label1.Text = ex.Message
Finally
If cn.State = ConnectionState.Open Then
cn.Close()
End If
End Try
It is returning me : Could not create an environment: OCIEnvCreate returned -1.