Consolidate the params for connect & create database

upscene · Post by **upscene** » Fri 27 Nov 2009 08:38

Hi,

Your documentation states:

Use the Params property to specify the connection parameters, such as user name, password, role etc. For example:

user_name=sysdba
password=masterkey
sql_role_name=role1
lc_ctype=WIN1252

If you are using Params property for creating a new database with the CreateDatabase function, you should set params like it is shown below:
USER "SYSDBA"
PASSWORD "masterkey"
PAGE_SIZE 4096

As you can see, the parameters for Create and Connect are different. For IBX, I never understood why, -except- that it directly passes them to the API.

Why can't you make this the same for both?! It's much easier to use! Please add compatibility for name=value parameters for CreateDatabase.

Plash · Post by **Plash** » Mon 30 Nov 2009 08:51

The CreateDatabase method executes CREATE DATABASE statement with parameters as you have specified in the Params property.
IBDAC does not parse these parameters.

upscene · Post by **upscene** » Mon 30 Nov 2009 09:04

Plash wrote:The CreateDatabase method executes CREATE DATABASE statement with parameters as you have specified in the Params property.
IBDAC does not parse these parameters.

That's exactly what I was saying

Please -do- check the params to see if you can modify them a bit before passing them, it makes programming easier.

Plash · Post by **Plash** » Mon 07 Dec 2009 08:54

We will investigate the possibility to add such functionality, but that is hardly to happen in the nearest future.