Subject Re: [IBO] Two databases in same project
Author stanw1950
--- 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
> Ensure that you have BOTH server and path and that your
windows/HOSTS file has this entry (it probably has, but do check):
> 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 (thanks to a tip from Mark O'Donohue). It had
been sitting there as, which I think was assigned to it
by Windows as a result of having two NICs numbered and 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?



> Cheers,
> Helen