NexusDB Embedded

PixAndMore · Post by **PixAndMore** » Sat 05 Nov 2011 07:11

Hello,

is there a way to use NexusDB as embedded Server with UniDAC?

If so, can you give me an example to create a database and connect at runtime?

AndreyZ · Post by **AndreyZ** » Mon 07 Nov 2011 14:48

Hello,

Yes, you can use NexusDB as Embedded database server and work with it using UniDAC. NexusDB database is represented by a folder (with the .nx1 files in it) on the hard disk. To work with such folder, you can use the following code:

Code: Select all

UniConnection.ProviderName := 'NexusDB';
UniConnection.Database := 'path';
UniConnection.LoginPrompt := False;
UniConnection.Open;
UniConnection.ExecSQL('create table test(id int)', []); // here the new table 'test' is created (test.nx1)

PixAndMore · Post by **PixAndMore** » Mon 14 Nov 2011 05:33

Hello,

thank you for your answer. I have tried to recompile the NexusDB provider, but I can't. In your source there are used "nexus...308" but from Nexus I have got the version 3.09. Changing the uses lines brings no solution, because there are some units unknown and in another module is a compilation failure...

Any ideas?

Regards, Kai

AndreyZ · Post by **AndreyZ** » Mon 14 Nov 2011 11:12

For the time being UniDAC supports NexusDB 3.08. We have already added NexusDB 3.09 support, it will be available in the next UniDAC build.