Error migrating to .NET 2.0 : OracleCommand DBCommand cast error

E

eclypse

After migrating our application to .NET 2.0 we're getting the following
error message
Unable to cast object of type 'Oracle.DataAccess.Client.OracleCommand'
to
type 'System.Data.Common.DbCommand'

I'm using Oracle.DataAccess.Client.
I'm getting the same message whether I'm using ODP.NET 9.2 or 10

This is the code we're using :

Dim tblSchema As New DataTable()
Dim adpAdapter As New OracleDataAdapter(pSqlString, DbConnection)
adpAdapter.FillSchema(tblSchema, SchemaType.Source)

Fillschema causes the error

This code used to work fine with .NET 1.1.

Thanks,
Oz
 
S

Sahil Malik [MVP C#]

The problem is probably "versions". Your
Oracle.DataAccess.Client.OracleCommand probably inherits from a different
version (1.1?) of DbCommand. And because they are SN'ed in GAC, you won't be
able to cast them and go your merry way. :(

Wait for a 2.0 version of ODP.NET? (February I think), or use Microsoft
OracleClient are reasonable solutions.


- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DirectoryServices Cast Error? 6
static method compile error when migrating from .NET 1.1 to 2.0 2
Started getting "InvalidOperationException was unhandled" since upgrading to .Net 2.0 3
Problem with Migrating from .net 1.1 to .net 2.0 2
Error "Cast from type 'DataRowView' to type 'String' is not valid" 2
Cannot run VS 2003 project using MSHTML, with .Net 2.0 1
combobox gives unexpected cast error 4
Convert Linq.DataQuery to DataTable 0

Top