Devart Forums

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

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);

Works now
After uninstall/install it again, I saw that I could activate the component now in the Install Packages dialog. Creating a new project was fine then, but the existing project couldn't find the components. This was because it was somewhere getting to ExcludedComponents section in the project file. Removed it and everything works fine now.

Luckily I don't need to reinstall the whole IDE again

Thanks.

I have even uninstalled XE3 to avoid complications with it. Same problem....
After a new installation, unidac160.bpl is present in SYSTEM32 and SYSWOW64. No change after renaming.

So I'm really stuck....

Hi,

after I uninstalled unidac there are no unidac*.bpl, uni*.dcu, mem*.dcu or dbacc*.dcu in the system. I install always using the install exe, after which the bpl dcus are there.

So I still don't see how to solve the issue.

Thanks.

I have uninstalled, no bpls were found somewhere, installed again.
Still the same message comes up for dclunidac160,bpl. In the component list all other devart components are ok, but not sclunidac160.

Hi,

I have installed UnidDac for XE2 again since a while. Now when I load a project with unidac components, I get the message "dclunidac160.bpl" needs recompilation before installing (i get the message in german language, so it might be a bit different from the original english text).

I don't have the sources. Any idea how to solve this problem ?

Thanks.

Hi,

I'm using a Firebird Database and I'm having the problem, if the ip is not available (e.g. no connection to the local network), it tries to connect forever. Is it possible to give a time, 10 seconds for instance, after which it the connect will be cancelled if not successful ?

TIA

Hi,

I'm using a firebird database on a server which is connected through a VPN. The connection is VERY slow, about 30 seconds for 50 records with 6 memo and 10 other fields. Not much data. But I can use many other applications with no problems. Even Remote Desktop is usable.

Question 1: Does anybody know how I can locate any problems ?
Question 2: A connection without active VPN will last forever. Is there any timeout I can set ?

Thanks for any hint.

Thanks, works fine !!!

...which is pretty much the same, isn't it ?

Hi,

I can't get a file saved in a blob field in a Firebird Database, here's the relevant code snippet:

// tblBinFILE is a TBlobField
// fn is a valid file name with complete path.

tblBin.Append;
tblBinFILENAME.AsString := fn;
tblBinTASK.AsInteger := id;
tblBinFILE.LoadFromFile(fn);
tblBin.Post;

I always get a

Dynamic SQL Error
SQL Error Code = -104
Token unknown - line 2, column 14
FILE.

I don't have any clue what's wrong

Can anybody help ?

TIA

Yes, there was another unique index, I was first looking in an older version of the table...
Thanks for the hint and *this DB component is really great*

Rgds

But the Primary Key Value is the AutoIncrement ID:

[ID] INTEGER PRIMARY KEY AUTOINCREMENT,

Hi,

using SQLite with UniDAC I always get an exception "constraint failed" at any point in time, can't really find out where exactly, or under which circumstances.

Anyone having an idea ?

Thanks