Wayne:

From the interbase.log file "gethostbyname" error it appears to be a
network issue. The error 11001 is "Host not found." The server
Roanoke_Server needs to resolve to an IP address so there may be a
configuration issue with your DNS server. Are you able to ping
Roanoke_Server form your client? Does it give you the IP address?

Have you tried connecting to the server using the IP address in place
of the server name?
<IPv4>:C:\Firebird\Examples\Employee.gdb
example:
127.0.0.0:C:\Firebird\Examples\Employee.gdb

You may need to add the server Roanoke_Server to your hosts file to
get the IP mapping?

Also, do you have IBConsole.exe on the server? Yes, I know it's not
supposed to work with FB but it's still working on FB version 1.0.
If so, on your server, where ibserver.exe is running try using
IBConsole to connect the database. This will verify that the server
is indeed running and able to connect via TCP on the localhost.

Dan

--- In ib-support@yahoogroups.com, "Wayne Elmore" <hwelmore@k...>
wrote:

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