Devart Forums

Hi,

I'm using UniDac 4.38 and user TUniConnection, TSQLiteUniProvider and TUniScript to create SQLite3 Database. Everything works fine, but when I try to use it in a SQLite client, I get the above error. I don't have any encryption on the db, but I heard that could be a version mismatch in SQLite. I presume that UniDac is creating SQLite3 db and not SQLIte2.

Any idea ?
Thanks

-------------------------------
I use the folowing code:

procedure Tdmod.CreateDB(AName: string);
begin
CloseDB;
// ---
Connection.SpecificOptions.Values['ForceCreateDatabase'] := 'True';
connection.Database := AName;
UniScript1.Execute;
end;

-------------- script: -----------------
DROP TABLE IF EXISTS "APP";

CREATE TABLE "APP" (
Name VARCHAR(30) PRIMARY KEY NOT NULL,
Prod CHAR(10),
Desc MEMO
);

DROP TABLE IF EXISTS "FIELD";

CREATE TABLE "FIELD" (
Name VARCHAR(30),
APP VARCHAR(30),
Desc MEMO
);

CREATE UNIQUE INDEX IDX_FieldApp ON Field (Name,App);

UniDAC only supports the SQLite3 format

Yes that was my assumption, but why do I get this error then ?

The "file is encrypted or is not a database" error may occur in case if the application connects to the SQLite database using a client library of a version incompatible with the one, that was used when creating the database. Please make sure your application uses the same sqlite3.dll library version, that was used when creating the SQLite database.