Subject Re: [firebird-support] Re: Connection problems with Classic
Author Thomas Steinmaurer
Hi Adam,

>>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.
>>
>>Thanks!
>
>
> Does
> telnet localhost 3050
>
> work? (screen should go blank)

Yes, for a few seconds, it goes to blank, but then I get back to the
command prompt, for instance, to

c:\Programme\Firebird\Firebird_200_3050\bin>

In the firebird.log file I get the following entries:

TOMSTONE Fri Feb 09 20:42:44 2007
inet server err: setting KEEPALIVE socket option



TOMSTONE Fri Feb 09 20:42:44 2007
inet server err: setting NODELAY socket option



TOMSTONE Fri Feb 09 20:42:44 2007
INET/inet_error: select in packet_receive errno = 10038


TOMSTONE Fri Feb 09 20:42:53 2007
inet server err: setting KEEPALIVE socket option



TOMSTONE Fri Feb 09 20:42:53 2007
inet server err: setting NODELAY socket option



TOMSTONE Fri Feb 09 20:42:53 2007
INET/inet_error: select in packet_receive errno = 10038


> Zonealarm rules don't always disable properly and many Firewalls
> re-enable the built in SP2 Firewall when shut down. You may have an
> exception defined for fbserver but not fb_inet_server.

That's not the reason.


Regards,
Thomas