Unhandled Database Exception 2

[bergis]

Hi
I am desperately trying to find an error in my database. I get this error message:
Unhandled database exception
Data truncated
ODBC RetCode: 1021

Does this give any clue to what might be wrong?

tia
Kjell

 

[foxdev]

What database system are you using? What is the statement you are passing to it? Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com

 

[tlbroadbent]

I think you a dealing with a known limitation of some versions of ODBC. Is the program attempting to insert more than 255 characters in a text or character column? Inserting more 255 characters may cause that error. Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I shall try to correct errors when shown to be errors, and I shall adopt new views so fast as they shall appear to be true views." - Abraham Lincoln

 

[bergis]

What I am doing is that I am using a programme that tries to access a certain table within an oracle database (on a server), and the error is very specific:
The program is for entering drilling (oilwells) data into the db and enters data in the following order:
Well->event->report->Day, and this error message only happens for one specific well, one spesific event, one spesific report on two spesific days. This error does not occur on any other days.

Kjell

 

[foxdev]

You may have to turn on ODBC Tracing in order to determine the exact statement being sent through ODBC that is causing the problem. This will help diagnose if it is the problem Terry referred to, or something related. Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com

 

[bergis]

Hi
I've tried running with ODBC tracing on and this is the part of the log that relates to the error:

dims32 4e0-430 ENTER SQLFetch
HSTMT 00D35C88

dims32 4e0-430 EXIT SQLFetch with return code 1 (SQL_SUCCESS_WITH_INFO)
HSTMT 00D35C88

DIAG [01004] [Microsoft][ODBC driver for Oracle]Error in column 1: Data truncated (0)

DIAG [01004] [Microsoft][ODBC driver for Oracle]Error in column 3: Data truncated (0)

dims32 4e0-430 EXIT SQLExtendedFetch with return code 1 (SQL_SUCCESS_WITH_INFO)
HSTMT 00D35C88
UWORD 1 <SQL_FETCH_NEXT>
SQLROWOFFSET 1
SQLROWSETSIZE * 0x00EE0F40 (1)
UWORD * 0x00F32660 (0)

DIAG [01004] [Microsoft][ODBC driver for Oracle]Error in column 1: Data truncated (0)

DIAG [01004] [Microsoft][ODBC driver for Oracle]Error in column 3: Data truncated (0)

If anyone has a clue to what this is telling me please let me know.
All help is greatly appreciated.

Kjell (new to odbc/oracle/access)

 

[bergis]

Problem seems to be solved..
If anyone is interested, what I eventually had to do was to change driver in ODBCAD32, from Microsoft ODBC for Oracle to Oracle 8.1 driver.
It seems that after a certain day there were to many entries for the Microsoft driver to handle.