--- In IBObjects@y..., Helen Borrie <helebor@d...> wrote:

> At 02:51 AM 01-01-02 +0000, you wrote:
> >I am trying to convert a large project from BDE to IBObjects. The
> >project uses two databases. Since I am testing locally,
>
> Stan, it is here:
>
> >both get the
> >same protocol (cpLocal), the same server (localhost),
>
> localhost is the TCP/IP local loopback server and your protocol

should be cpTCP_IP, not cpLocal. There is probably a living
nightmare going on in IB's network layer! Localhost is for TCP/IP
local loopback,

>
> >but different
> >paths (to different databases).
>
> The path should be "local to the server" but, because you have

server and client on the same machine, in reality they appear the
same.

>
> Ensure that you have BOTH server and path and that your

windows/HOSTS file has this entry (it probably has, but do check):

>
> 127.0.0.1 localhost
>
>
> If you find that in fact there is no HOSTS file there, just copy

the file name Hosts.SAM and rename it to HOSTS. Open this file using
Notepad and uncomment (remove # from) the line identifying localhost.

>
> One extra thing I discovered that sped up local loopback's initial

connection speed was to explicitly select the local loopback virtual
adapter (select it from the adapter list) AND to go in and properly
set it to 127.0.0.1. (thanks to a tip from Mark O'Donohue). It had
been sitting there as 192.12.13.3, which I think was assigned to it
by Windows as a result of having two NICs numbered 192.12.13.1 and
192.12.13.2 respectively.

>
> As Mark pointed out, the loopback just loops around and around

trying to get a unique gateway and eventually just times out and
finally gets success by using the genuine localhost IP as an absolute
last resort. Your objective should be for it to whack to the correct
IP by the shortest possible route.

>
> Take IPX/SX right out of your protocol list, too, if it's there.
>

**********************************************************
**********************************************************
Helen, thanks.

I changed the protocol to both databases (and yes they are
tibodatabases) to cpTCP_IP. I made sure that a hosts files exists
with the entry below. But the problem still exists. So, to clarify, I
have two databases set up as:

database1: path = c:\databases\db1.gdb
server = localhost
protocol = cpTCP_IP
database2: path = c:\databases\db2.gdb
server = localhost
protocol = cpTCP_IP

Also, I am running Interbase 6.5 (not 6.0).


I am reasonable familiar with the network in control panel, but I do
not see where I select the local loopback virtual adapter. I have
three adapters - Dial-up adapter, Dial-up adapter #2 (VPN support),
and Microsoft Virtual Private Networking Adapter (I use VPN to get to
work from home). I don't see a local loopback adapter in the add
adapters list, nor do I see that property in any of the adapters or
in TCP/IP. Where do I set it?

Thanks,
Stan

**********************************************************
**********************************************************

>
> Cheers,
> Helen