DataAdapter wizard and Oracle table - error


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
 
Ad

Advertisements

C

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!
**********************************************************************
Julian said:
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.
 

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

Top