DataAdapter wizard and Oracle table - error

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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!
**********************************************************************
Julian said:
Hi,
While trying to use the OleDbDataAdapter wizard to create a DataAdapter
Click to expand...
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
Click to expand...
oracle.Datatype is not supported.
 
Back
Top