Values from Access database via ODBC are getting truncated

[Robert B]

This issue is specific to one PC. It is running Windows XP Pro sp3 and
connects to an Access (2003) dastabase via MS Access ODBC (Mdac 2.8). The
problem is values from the database are being truncated, (ie. a string data
type value of '1.0.1234' is being returned as '1.0.1'. I've made a test
version of the same application but using an OLEDB type connection and the
correct value ('1.0.1234') is read.

Out of hundreds of deployments, this is the first time I've run across this.
I've looked for settings for ODBC on the PC but haven't found anything
unusual.

Any suggestions as to where to look or a probable cause would be greatly
appriciated.

Thank You,

Robert

[Mary Chipman [MSFT]]

Is it being truncated in the database, or just the UI?

--Mary

[Pak-Ming Cheung - MSFT]

My wild guess is that the length of the buffer isn't setup properly.

Since it truncated at middle, the most likely reason is related to unicode /
multibyte.

Please pay close attention to the data retrieval function, and whether you
are binding to unicode or multibyte.

Thanks,
Ming.
MDAC Team, Microsoft.

P.S. We recommend customers to use the forum to ask questions in the future,
where you can obtain a faster response (Forum is at:
http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/threads/)