How to fix problem with Access treating DB2 BIGINT as TEXT?

M

Marina

MS-Access does not recognize BIGINT as a number and it produces an ODBC error
when BIGINTfield is used in selection criteria.

[IBM][CLI Driver][DB2/6000] SQL0401N The data types of the operands for the
operation "=" are not compatible. SQLSTATE= 42818

Is there a fix or work around?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DCount and Date format Question Against IBM DB2 Date 2
Excessive database access time? 1
Excel linked to Access w/"Like" not working 3
Problem with mail merge using Access Database as source 1
Importing Data from Access to Excel VBA code help 0

Top