At 11:50 AM 4/04/2007, you wrote:

>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?

Yup.

>/*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^

A remote terminal client (which is what your command shell is on
vista) can't use a local connection to create a database.

Needs to be
CREATE DATABASE 'hostname:C:\Chreos Shared\Data\Soul\ChreosAccounts.fdb'

where hostname is the network name of the server. You cd try
localhost but some experiences seem to suggest that Vista disallows
localhost connections by default. (Can't test it: I don't have
Vista and don't intend to have it).

Helen