[Lazarus] ODBC-problems

[Reinier Olislagers]

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.

Reinier