Re: VB Oracle Error : 80004005 SQL Data type out of range <2>

• Previous message: Erland Sommarskog: "Re: Problem Inserting Data"
• In reply to: Sumit Kapoor: "Re: VB Oracle Error : 80004005 SQL Data type out of range <2>"
• Messages sorted by: [ date ] [ thread ]

Date: Sun, 19 Dec 2004 23:46:42 +0000 (UTC)

Sumit Kapoor (SumitKapoor@discussions.microsoft.com) writes:
> Thanks for reply...But i'm sorry to say that I didn't get exact answer
> of my question...
>
> instead of getting hint of my question I need to suggest you for clear you
> concept..
> check this link.
> http://msdn.microsoft.com/library/default.asp?url=/library/en-
> us/ado270/htm/mdmthaddnewx.asp
>
> it'll let you know how to use AddNew().
> Thanks again for try to solve my issue.
 
That's what you get for asking questions about ADO and Oracle in a group
which is aimed for the OLE DB API.

I don't know Oracle, so there is not much I can do. But the message appears
to come from either Oracle, or the Oracle ODBC driver. Possibly you have an
outdated driver, and the in the table you have some data type that the
ODBC driver does not use.

One idea is to change from using the default provider - OLE DB over ODBC -
MSDAORA, which is the Oracle OLE DB provider.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Previous message: Erland Sommarskog: "Re: Problem Inserting Data"
• In reply to: Sumit Kapoor: "Re: VB Oracle Error : 80004005 SQL Data type out of range <2>"
• Messages sorted by: [ date ] [ thread ]