FYI: ORA-12571, Unicode and ODBC

From: Niles Ritter <nritter_at_elite.com>
Date: 5 May 2003 15:46:20 -0700
Message-ID: <9c1e14b8.0305051446.18cb3be6_at_posting.google.com>



This is just a public-service FYI about an ODBC operation that can cause error ORA-12571, TNS packet failure, that I have not seen mentioned elsewhere. It took me a solid day in the debugger to figure out what was wrong, so hopefully this will save someone else equal grief.

If you call SQLBindParameter to bind in a unicode (UTF-16) formatted character string, but the memory address of your buffer is odd, upon execution you will get the ORA-12571 error message. I have seen this happen on Windows client boxes, but assume that this could also happen on other platforms.

 --Niles Ritter
   Elite Information Systems, Inc. Received on Tue May 06 2003 - 00:46:20 CEST

Original text of this message