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

From: Sumit Kapoor (_at_discussions.microsoft.com)
Date: 12/19/04 

Date: Sat, 18 Dec 2004 23:57:05 -0800

Hi Friend,

I'm facing very strange problem..
when I insert record in DB then it stop at addnew()
& give error
                   
                 Runtime Error '-2147467259 (80004005)';
                 [ORACLE][ODBC] SQL data type out of range <2>.

There are few fields that are getting values assigned to then even one LONG
field.

Error Condition :
     
              RecordSet1.Open()
              RecordSet1.AddNew() ///////////// POINT OF ERROR////////
              RecordSet1.Field(0)="123"
              RecordSet1.Field(1)="123"
              RecordSet1.Update()
              RecordSet1.Close()

If anybody can help me then it would be great help for me.
if possible please e-mail me at : sumit_kapoor1980@yahoo.com

I HOPE YOU WILL HELP ME
Thanks
Sumit

Relevant Pages