[Date Prev][Date Next][Thread Prev][Thread Next]
[Date Index]
[Thread Index]
- Subject: Re: Assertion failed when trying to use ODBC in Windows 7 64 bit
- From: Dimiter 'malkia' Stanev <malkia@...>
- Date: Thu, 08 Mar 2012 15:47:59 -0800
Maybe Ignacio is right. SQL_WCHAR is not handled by the lua wrapper, and
it's possible that SOCDOS is WCHAR.
Can you change your SQL (assuming Oracle SQL):
FROM: SELECT ZDEA.SOCDOS, ....
TO: SELECT TO_CHAR(ZDEA.SOCDOS), ....
According to this TO_CHAR should be available:
http://psoug.org/reference/convert_func.html
Aat least to get it pass through the assert. Later you might have to
convert it to a blob or binary and handle it some other way.
(Just guessing. I've only had experience with SQLite & MySQL, and
through C#/C++ (not lua))
On 3/8/2012 1:45 PM, Szabó, Ferenc wrote:
@ Ignacio Burgueño:
SOCDOS is a simple char(3).
*
*
@ Dimiter 'malkia' Stanev:
I would do that. How could I print/log the actual code? I do not know C.
Shall I need a C compiler?
Actually the driver is 32 bit driver of DataDirect Connect for ODBC for
Oracle 8.1.6 (this version is not supported by Oracle for Windows 7) and
I have no support for the DataDirect driver yet as the support period is
already over. :( (Pure me.)
So everything is identical except the OS that changed to 64 bit. I can
use the ODBC with other programs (eg. MS Office) without problem.