Your wonderful !

Thanks Helen. Changed to using the Server host and it works perfectly.

That really helps me out heaps. I was really scratching my head with
that one !

p.s. This is the exact reason I have a Vista machine (beside the one I
actually work on).

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Helen Borrie wrote:

> 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
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
>