Subject | IB_Script and create database failing on Vista machine |
---|---|
Author | Robert martin |
Post date | 2007-04-04T01:50:23Z |
Hi
Another issue ...
We have an application that automatically creates a DB based on a
script. This works fine. However on my Vista test machine it is coming
up with an 'Invalid Create, Connect or Drop syntax' error message. I
wondered if it was our old components so created a test app in the
latest IBO release and in D2007. I still get the same error message.
The start of the script is shown below.
Any ideas?
/*VERSION=3.0.959.101,3.0.959.101,3.0.959.101*/
/* Last update : 20/03/2007 */
/* Updated By : RM */
/* Released 23/02/2007 */
SET TERM ^ ;
/* Connect using username: SYSDBA */
/* and server: WI-V6.3.1.4481 Firebird 1.5 */
SET SQL DIALECT 3^
SET AUTODDL ON^
CREATE DATABASE 'C:\Chreos Shared\Data\Soul\ChreosAccounts.fdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 8192
DEFAULT CHARACTER SET NONE^
CREATE GENERATOR WORKCONTROL_Gen^
....
--
Rob Martin
Software Engineer
phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd
Another issue ...
We have an application that automatically creates a DB based on a
script. This works fine. However on my Vista test machine it is coming
up with an 'Invalid Create, Connect or Drop syntax' error message. I
wondered if it was our old components so created a test app in the
latest IBO release and in D2007. I still get the same error message.
The start of the script is shown below.
Any ideas?
/*VERSION=3.0.959.101,3.0.959.101,3.0.959.101*/
/* Last update : 20/03/2007 */
/* Updated By : RM */
/* Released 23/02/2007 */
SET TERM ^ ;
/* Connect using username: SYSDBA */
/* and server: WI-V6.3.1.4481 Firebird 1.5 */
SET SQL DIALECT 3^
SET AUTODDL ON^
CREATE DATABASE 'C:\Chreos Shared\Data\Soul\ChreosAccounts.fdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 8192
DEFAULT CHARACTER SET NONE^
CREATE GENERATOR WORKCONTROL_Gen^
....
--
Rob Martin
Software Engineer
phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd