Page 1 of 1

Consolidate the params for connect & create database

Posted: Fri 27 Nov 2009 08:38
by upscene
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.

Posted: Mon 30 Nov 2009 08:51
by Plash
The CreateDatabase method executes CREATE DATABASE statement with parameters as you have specified in the Params property.
IBDAC does not parse these parameters.

Posted: Mon 30 Nov 2009 09:04
by upscene
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.

Posted: Mon 07 Dec 2009 08:54
by Plash
We will investigate the possibility to add such functionality, but that is hardly to happen in the nearest future.