Bruce
Bruce

Reputation: 115

Does FireDAC support SQLite extensions?

I'm trying to load the mathematical statistics module stats from the sqlean-win-x86.zip archive (32-bit version) for SQLite database using FireDAC Connection Editor (SQL Script tab):

SELECT load_extension('C:\Test\stats');

But I always get the following error:

The specified module could not be found

When I use stats from sqlean-win-x64.zip (64-bit version), I'm getting another error:

%1 is not a valid Win32 application

This means that FireDAC was able to find the specified module.

The Extensions parameter in the Definition tab is set to True and the connection to a database is successful.

What am I doing wrong? Does FireDAC support SQLite extensions?

I'm using RAD Studio 11.2 and its FireDAC 28.0.0.

SQLite Studio loads the same extension from the same folder without any problem.

Upvotes: 0

Views: 70

Answers (0)

Related Questions