At 10:23 AM 9/02/2007, you wrote:

>Hello,
>
>I encounter weird connection problems with Classic whereas the same
>connection string works fine with Superserver. This happens for both
>Firebird 1.5.3 and Firebird 2.0.0 on the same machine with Windows XP
>Prof. SP2.
>
>For example, I've an alias defined "employee.fdb". With Superserver I
>can connect with isql by using a connection string of
>localhost:employee.fdb. The same fails under Classic with the following
>error messages:
>
>- Firebird 1.5.3
>
>c:\Programme\Firebird\Firebird_153_3050\bin>isql
>Use CONNECT or CREATE DATABASE to specify a database
>SQL> connect localhost:employee.fdb user sysdba password masterkey;
>Statement failed, SQLCODE = -902
>
>Unable to complete network request to host "localhost".
>-Failed to establish a connection.
>SQL>
>
>- Firebird 2.0.0
>
>c:\Programme\Firebird\Firebird_200_3050\bin>isql
>Use CONNECT or CREATE DATABASE to specify a database
>SQL>
>SQL> connect localhost:employee.fdb user sysdba password masterkey;
>Statement failed, SQLCODE = -923
>connection rejected by remote interface
>SQL>
>
>
>As said, the same connection string works fine with Superserver. Tests
>have been made with Firewall (ZoneAlarm) enabled and disabled. Doesn't
>matter.
>
>As I want to use Classic on my new Core 2 Duo laptop, I would appreciate
>any help.

Thomas, just as a reality check, was the above sample a copy/paste
from the isql shell? If so, where are the quotes on the strings?

SQL> connect localhost:employee.fdb user sysdba password masterkey;

should be

SQL> connect 'localhost:employee.fdb' user 'sysdba' password 'masterkey';

Whereas, directly from the command shell, they are a parameter and
switches to isql and don't take quotes:

xxx\bin> isql localhost:employee.fdb -user sysdba -password masterkey

./heLen