Creating a database with UniDAC

[upscene]

Hi,

can you give me an example on how to create a database with UniDAC?

I have no problem using TGDSConnection for that, this is entirely possible in my application.

Thanks,

Martijn Tonies
Upscene Productions

[Plash]

To create a Firebird/InterBase database, use the TUniScript component with CREATE DATABASE statement in it. Set the Preconnect property of TUniScript to False.

[upscene]

To create a Firebird/InterBase database, use the TUniScript component with CREATE DATABASE statement in it. Set the Preconnect property of TUniScript to False.

Sounds like an easy to use work around

Any example for Drop Database as well?

[Plash]

Execute the DROP DATABASE statement in TUniScript.

[Farhan]

Can you give us an example that how can we create database using .sql text files?please share a demo using uniscript and unidac. thanks.

[Plash]

Use the SQL text like the following:

Code: Select all

CREATE DATABASE 'C:\db.gdb'
USER 'sysdba' PASSWORD 'masterkey'
PAGE_SIZE 4096

Use the Pascal code like the following:
UniScript1.SQL.LoadFromFile('sql.txt');
UniScript1.NoPreconnect := True;
UniScript1.Execute;

Code: Select all

[99Percent]

Correct me if I am wrong but this doesn't work in PostgreSQL if you don't have a database already created because the Connection property requires a database, even if Nopreconnect=True;

edited to add: I discovered that the default installation of PostgreSQL (at least in 8.4) creates a default database "postgres". My mistake was deleting this default database. I suggest you don't delete it if you plan to programmatically create databases, until atleast one database is created because its a real hassle to create new databases without an initial database since the user login generally requires a database to log on to.