DataAdapter wizard and Oracle table - error

[Guest]

Hi,
While trying to use the OleDbDataAdapter wizard to create a DataAdapter and trying to generate a Select statement, I get the following error.

Generated Select statement.
Oracle error occurred,but error messages could not be retrieved from oracle.Datatype is not supported.

I have 97 fields in my oracle table.

What could the error be ? Where should I start looking ?

Thank You
Julian

 

[Cowboy \(Gregory A. Beamer\)]

I would call the Wizard into your office and fire him. ;->

I would either use the Microsoft OracleClient provider (and dump the wizard)
or, better yet, with the Oracle .NET drivers (free download from
http://otn.oracle.com - have to register, but worth it). You will end up
coding the conn, et al, yourself, but it is worth it.

The error is either in an incorrect data type, or with a namespace that
needs to be referenced.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************

Hi,
While trying to use the OleDbDataAdapter wizard to create a DataAdapter

and trying to generate a Select statement, I get the following error.

Generated Select statement.
Oracle error occurred,but error messages could not be retrieved from

oracle.Datatype is not supported.