Subject Re: Can't connect to server
Author nitaligavino <Dan.Crea@apropos.com>
Hello:
By default FB is on TCP 3050, I believe you can change this however,
so to see if FB is indeed listing on this port run:
c:\>netstat -n

Proto Local Address Foreign Address State
TCP 127.0.0.1:2417 127.0.0.1:2416 ESTABLISHED
TCP 127.0.0.1:2419 127.0.0.1:3050 ESTABLISHED
TCP 127.0.0.1:3050 127.0.0.1:2419 ESTABLISHED
...

For example, this output came form my local box, where FB is running
and shows that port 3050 is ESTABLISHED. If you don't see this in
your dump then ibserver.exe is not running.

Try looking at the interbase.log to see if there is any error's. You
can also look at the event log, assuming Windows.

Also you can try running ibserver from the command line

c:\>ibserver.exe -a
The -a is for application. In this mode ibserver will run as an
application and there should be a tray icon that you can click to
view some server info.

Hope this helps
Dan

--- In ib-support@yahoogroups.com, "Wayne Elmore" <hwelmore@k...>
wrote:
> I'm in the process of converting desktop applications to Firebird
SQL.
>
> I cannot connect to the Firebird SQL database on the server.
> Firebird version: WI-V6.2.794 using IB_SQL to try and access the
> databases on the server. When I try to connect to the
Roanoke_Server I get
> the message 'unable to make connection to Roanoke_Server'. The
string I'm
> using is Roanoke_Server:C:\Firebird\Examples\Employee.gdb 'C:'
being the
> drive on the server. I've used garbage in place of Roanoke_Server
and get
> the error message 'Failed to locate the host machine'. Therefore,
I'm
> assuming that the Roanoke_Server is being found but something is
preventing
> the completion of the connection.
>
> Someone stated that Firebird listens via TCP on port 3050. After
loading
> Firebird, I've run netstart on both the server and my workstation
with the
> following results:
>
> Server
> Proto Local Address Foreign
Address
> State
> TCP roanoke_server:1046
ROANOKE_SERVER:nbsession Established
> TCP roanoke_server:2673
ROANOKE_SERVER:135
> Time_Wait
> TCP roanoke_server:2674
ROANOKE_SERVER:1037
> Time_Wait
> TCP roanoke_server:nbsession ROANOKE_SERVER:1046
> Established
> TCP roanoke_server:nbsession WAYNE:1077
Established
> TCP roanoke_server:1026
LOCAL_HOST:1027
> Established
> TCP roanoke_server:1027
LOCAL_HOST:1026
> Established
>
> My Workstation
> TCP 1:1077
ROANOKE_SERVER:nbsession
> Established
>
> How do I access port 3050?
>
> >From my workstation I can ping the server using either the name
> Roanoke_Server or it's IP address of 10.202.1.1.
>
> Someone also said that address 10.xxx.xxx.xxx will not route. If
not then
> does this mean that I'm going to have to get a registered IP
address for
> the server?
>
> Any help will be greatly appreciated.
>
> Thanks
> Wayne