Unable to complete network request to host -Failed to locate host machine

By: Borland Staff

Abstract: This error can be generated, because the BDE alias has been setup incorrectly.

Problem:
When trying to connect to InterBase through a BDE alias the 
following error message is generated:

           Unable to complete network request to host 
           -Failed to locate host machine

This error can be generated, because the BDE alias has been 
setup incorrectly.  One cause of this error message is when 
the BDE alias has the machine and path setup in the aliases 
PATH parameter instead of the SERVER NAME parameter.

Note:  This is a client problem not a server problem.



Solution:
The information in this article applies to:
  * InterBase v4.x
  * InterBase v5.x
  * BDE all versions > v3.51

Make sure that the PATH parameter of the alias is blank and 
the SERVER NAME parameter is setup correctly.


Following are examples of correct SERVER NAME parameters:

For local access:
      c:ibserverexamplesemployee.gdb

For network access using netbeui:
      serverc:ibserverexamplesemployee.gdb

For network access using TCP/IP
      server:c:ibserverexamplesemployee.gdb [Win NT]
      server:/usr/interbase/examples/v4/employee.gdb [Unix]


Example of a correctly setup BDE alias:

    TYPE		INTRBASE
    PATH		
    SERVER NAME	server1:c:ibserverexamplesemployee.gdb
    USER NAME		SYSDBA
    OPEN MODE		READ/WRITE
    SCHEMA CACHE SIZE	8
    LANGDRIVER
    SQLQRYMODE	
    SQLPASSTHRUMODE	SHARED AUTOCOMMIT	
    SCHEMA CACHE TIME	-1


Server Response from: ETNASC03