Pass through query to oracle db

[LRS]

I have a pass through query that works except that there is an Admin table
created that that have the message "01004 - 0 - [Oracle][ODBC]String data,
right truncated." in every field. The number of rows created when I run the
PTQ is different each time.
Is this anything I need to be concerned about? What does it mean?
Confused,
Lisa

 

[vanderghast]

Either a fiedl in a table in Oracle is not designed to have enough room (say
it is designed to hold 25 characters and you want to save 26 characters in
it, or more), either the table in Jet has a field in one of its table which
does not have enough room. Do you append data into Oracle from Access? or
do you read data from Oracle, and send it to Access?

It may be important if your strings are not simply filled with spaces (so,
luckily, only those extra spaces would be lost).

Try to append (read) only ONE record and check all its fields where you
create them (in Oracle or in Access) by comparison with the original values
they should have.



Vanderghast, Access MVP

 

[LRS]

I am reading oracle data and send it to Access. I will try a single record
and see if all is there.
Thanks!

Either a fiedl in a table in Oracle is not designed to have enough room (say
it is designed to hold 25 characters and you want to save 26 characters in
it, or more), either the table in Jet has a field in one of its table which
does not have enough room. Do you append data into Oracle from Access? or
do you read data from Oracle, and send it to Access?

It may be important if your strings are not simply filled with spaces (so,
luckily, only those extra spaces would be lost).

Try to append (read) only ONE record and check all its fields where you
create them (in Oracle or in Access) by comparison with the original values
they should have.



Vanderghast, Access MVP

I have a pass through query that works except that there is an Admin table
created that that have the message "01004 - 0 - [Oracle][ODBC]String data,
right truncated." in every field. The number of rows created when I run
the
PTQ is different each time.
Is this anything I need to be concerned about? What does it mean?
Confused,
Lisa