Subject Re: Connection problems with Classic
Author Adam
> >>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>

That is quite strange. I get a black screen indefinitely (or until the
fb_inet_server process terminates anyway) when the server is running,
or an error message such as connection refused if the service is not
running or a firewall is 'in the way'.

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

10038 is a winsock error, I don't know if that helps things.

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

I don't use Zonealarm anymore but used to with classic server on xp
sp2, so I know it can work. As long as your confident you have
configured the appropriate program exceptions.

I notice that you are installing to a non-default location which I
have never done before with classic. Also, as another reality check,
try ping localhost and make sure it resolves to 127.0.0.1.

Adam