can not load client library sqlite3.dll
Posted: Tue 26 Sep 2017 06:37
Hello,
I'm using Delphi XE7, UNIDAC 6.1.3,Windows 7 X64,compiling project for X86 platform.
I'm trying to create sqlite database on runtime found below code in forum;
when i run it system returns "Can not load client library sqlite3.dll", searched through forum and google and find some solutions but none of it worked.
-Copied sqlite3.dll to the same folder with exe - not solved
-Tried to set sqlite3.dll path via component settings as "C:\myapp\bin\sqlite3.dll" - not solved
Another strange thing is when i try to connect any sqlite database it returns the same error, but if i follow this;
-Double click to uniconnection
-Options->Direct->True
then it's connecting to database without any problem.
In this case i need to create database and tables on runtime that's why i can not add uniconnection to my form, any ideas ?
I'm using Delphi XE7, UNIDAC 6.1.3,Windows 7 X64,compiling project for X86 platform.
I'm trying to create sqlite database on runtime found below code in forum;
Code: Select all
var
UniConnection: TUniConnection;
begin
UniConnection := TUniConnection.Create(nil);
UniConnection.ProviderName := 'SQLite';
UniConnection.Database := 'C:\NewTetsDB.db3';
UniConnection.SpecificOptions.Values['ForceCreateDatabase'] := 'True'; // In UniDAC 4.5.9 and higher
UniConnection.Connect;
UniConnection.ExecSQL('PRAGMA auto_vacuum = 1');
-Copied sqlite3.dll to the same folder with exe - not solved
-Tried to set sqlite3.dll path via component settings as "C:\myapp\bin\sqlite3.dll" - not solved
Another strange thing is when i try to connect any sqlite database it returns the same error, but if i follow this;
-Double click to uniconnection
-Options->Direct->True
then it's connecting to database without any problem.
In this case i need to create database and tables on runtime that's why i can not add uniconnection to my form, any ideas ?