Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle.DataAccess.Client.OracleConnection vs. System...

555310Jan 9 2007 — edited Jan 11 2007
I am wondering why this code:

**************************************************************************
Dim builder As New Oracle.DataAccess.Client.OracleConnectionStringBuilder
builder.DataSource = "datasourcename"
builder.UserID = "user"
builder.Password = "pass"

Dim oraConn As Oracle.DataAccess.Client.OracleConnection = New Oracle.DataAccess.Client.OracleConnection(builder.ConnectionString)

Dim oraCMD As New Oracle.DataAccess.Client.OracleCommand("SELECT field1, field2 FROM table", oraConn)

Dim MyDA As New Oracle.DataAccess.Client.OracleDataAdapter(oraCMD)

Dim ds As New DataSet

MyDA.Fill(ds)
DataGrid1.DataSource = ds.Tables(0)
**************************************************************************

throws a "Object reference not set to an instance of an object." at the line "MyDA.Fill(ds)"

and this code runs fine:

**************************************************************************
Dim builder As New System.Data.OracleClient.OracleConnectionStringBuilder
builder.DataSource = "datasourcename"
builder.UserID = "user"
builder.Password = "pass"

Dim oraConn As System.Data.OracleClient.OracleConnection = New System.Data.OracleClient.OracleConnection(builder.ConnectionString)

Dim oraCMD As New System.Data.OracleClient.OracleCommand("SELECT field1, field2 FROM table", oraConn)

Dim MyDA As New System.Data.OracleClient.OracleDataAdapter(oraCMD)

Dim ds As New DataSet

MyDA.Fill(ds)
DataGrid1.DataSource = ds.Tables(0)
**************************************************************************

Any thoughts?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 8 2007
Added on Jan 9 2007
2 comments
1,676 views