ODBC: Width of a Unicode text Column...

[Tim Marshall]

Hi folks.

In A2003, I am sometimes getting an error when I try to open a pass
through query or display, via DAO, field information from an ODBC
connected table. I've never generated this error in A97 apps and,
indeed, this is happening on A2003 apps converted from very robust A97
apps that operated for years (and still operate) reliably.

The error is:

3702 The width of a unicode text column must be an even number of bytes.

Anyone know what this is referring to and what to do about it? My c/s
back end is Oracle 8i if that makes any difference.

Thanks in advance.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[Tim Marshall]

Tim Marshall wrote:

The error is:

3702 The width of a unicode text column must be an even number of bytes.

Don't you just love it when you post a question and then stumble onto or
figure out the correct response? 8)

Not sure if this is a win XP or other issue, but in the control panel,
under admin sources -> Data Sources (ODBC), highlight the DSN in
question and select "Force Retrieval of Long Columns" in the workarounds
section.

Hope this is of some help to future googlers! 8)
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me