If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: DB2 database data in Access

DB2 v7 fp10.

Our users are facing problem where they are unable to display certain kind of data through MS Access. The data type in question is BINRAY and it's very inconsistent. Data is displayed correctly for some BINRAY fileds but not for all. Could this be a problem with ODBC driver? Or something else need to be setup?

Backend=´DB2

I'm suggesting you add a column in the DB2
database table. Next to your binary column.
Then update that column using the Hex() values
of the original column , and let the MSAccess users
use the new column instead

I'm suggesting you add a column in the DB2
database table. Next to your binary column.
Then update that column using the Hex() values
of the original column , and let the MSAccess users
use the new column instead

If you do this you'll probably want some triggers to keep the new column in sync on INSERTs and UPDATEs.

Access stinks, there should be a way to change the display of Binary data to be more like Db2's, ie. display it in hex... interpreting it as characters is goofy.