Subject | Re: [IBO] creating a new database |
---|---|
Author | Paul Vinkenoog |
Post date | 2002-11-26T12:55:48Z |
Hi Duilio,
you too. But this is how I do it in a project of mine:
- Make sure there's a TIB_Connection with the Server and Protocol
fields set.
I also set User en Password before executing the script; not sure
if this is necessary as they also appear in the script itself.
- Have the IB_Connection field of the TIB_Script point the the
abovementioned TIB_Connection. The IB_Transaction field in my case
is <default>
- My script SQL starts like this:
set sql dialect 3;
create database '<<PATH>>'
user '<<USER>>'
password '<<PASS>>'
page_size 8192
default character set ISO8859_1
;
...
...
You don't explicitly connect the TIB_Connection. It is Connected as
soon as the "create database" clause is executed. I know this because
I once ran into trouble with an AfterConnect handler that was called
before the rest of the script had been carried out.
Hope this helps,
Paul Vinkenoog
> I use IBO3 with D3.I use IBO4 with BCB5. So I'm not sure if what works for me, works for
you too. But this is how I do it in a project of mine:
- Make sure there's a TIB_Connection with the Server and Protocol
fields set.
I also set User en Password before executing the script; not sure
if this is necessary as they also appear in the script itself.
- Have the IB_Connection field of the TIB_Script point the the
abovementioned TIB_Connection. The IB_Transaction field in my case
is <default>
- My script SQL starts like this:
set sql dialect 3;
create database '<<PATH>>'
user '<<USER>>'
password '<<PASS>>'
page_size 8192
default character set ISO8859_1
;
...
...
You don't explicitly connect the TIB_Connection. It is Connected as
soon as the "create database" clause is executed. I know this because
I once ran into trouble with an AfterConnect handler that was called
before the rest of the script had been carried out.
Hope this helps,
Paul Vinkenoog