Dan, thanks for your prompt reply. The following for your further
consideration.

I ran netstat -n on my workstation and got the following for port 3050
Proto Local Address Foreign Address State
TCP 1:3050 Wayne:0 Listening

along with other local addresses with the same foreign address and state.
Should the local address should be the server IP?

The interbase log shows the following errors when I try to connect.

WAYNE ELMORE (Client) Tue Jan 07 13:02:12 2003
INET/INET_connect: gethostbyname failed, error code = 11001

WAYNE ELMORE (Client) Tue Jan 07 13:02:18 2003
INET/INET_connect: gethostbyname failed, error code = 11001

Also,
Ibserver.exe is on the server. I've placed a shortcut on my desktop to
access and run Ibserver and the tray icon appears on my workstation. So,
the server is running; however, maybe I loaded Firebird incorrectly? After
downloading Firebird, I installed it on the server from my desktop, placed
a shortcut on my desktop to the directory where ibserver.exe resides. When
I run ibserver.exe from my shortcut, a tray icon does appear on my desktop.
Right clicking the icon shows the path to the server from which it came.
Anything else I should do?

Thanks
Wayne
----------

> From: nitaligavino <Dan.Crea@...>
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Re: Can't connect to server
> Date: Tuesday, January 07, 2003 01:40 PM
>

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