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.
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