[Lazarus] ODBC-problems

[michael.vancanneyt at wisa.be]

On Tue, 20 Nov 2012, Reinier Olislagers wrote:

> On 20-11-2012 13:40, michael.vancanneyt at wisa.be wrote:
>> On Tue, 20 Nov 2012, Reinier Olislagers wrote:
>>> On 20-11-2012 12:23, Koenraad Lelong wrote:
>>>> On 20-11-12 12:13, Koenraad Lelong wrote:
>>>>> In Win7 64 bit only the system DSN of Firebird works.
>>>>>
>>>> Sorry, should be user DSN works, system DSN does not work.
>>>>
>>> As you're using 32 bit Lazarus, just to be sure:
>>>
>>> please confirm the DSNs you are using are defined in the 32 bit ODBC
>>> control panel (using 32 bit Firebird ODBC drivers), not the 64 bit
>>> ones...
>>> That error message seems to indicate some bitness mismatch between
>>> application<>ODBC<>ODBC driver
>>
>> That's what I wanted to establish.
> Yep, thought so when you wrote that post ;)
>
>> The best solution IMHO is to work fully in 64-bit:
>> Firebird
>> Lazarus
>> Windows.
>> and not to attempt mixing things.
>
> Well... I'd say: even on Win64, keeping
> Firebird
> Lazarus
> 32 bit is better (unless memory etc requires 64 bit compilation) as 64
> bit embedded Firebird on Win64 will give
> - unexpected exceptions or
> - just won't work (http://bugs.freepascal.org/view.php?id=21581)
> Those can be fixed with Sergei's SEH build (-dTEST_WIN64_SEH) though.

The problem is not so much Lazarus, but ODBC. We've had strange reactions on
a 64-bit system depending on the 32/64 version of the drivers installed...

Michael.