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
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 ?