By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,069 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

ODBC: Width of a Unicode text Column...

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.