[fpc-pascal] Cannot use SQLite 64 bit dll

[Michael Van Canneyt]

On Sun, 21 Oct 2018, Dennis wrote:

> A simple test here with a SQLite3Connection works without problems.
>>
>> Do you get an exception if the library is *not* located in the same 
>> folder? In that case it loaded correctly and something else must be 
>> the problem.
>>
>> Regards,
>> Sven
>> _______________________________________________
> I deleted the library from the exe folder and surprisingly it behaved 
> exactly the same. it just waited a few seconds before quitting silently. 
> No except was thrown.
> I suspect the exe tries to link to the sqlite dll somewhere in the 
> search path, which is a 32 bit version, so it quits silently after 
> finding out it is not a 64 bit dll.
>
> How can I force SQLite3Connection to first look for the dll in the exe 
> folder instead of from the search path?

That should be the case automatically.

You can also use a TSQLDBLibraryLoader  component to specify the library location
exactly. If you use lazarus, it's on the component palette.

Michael.