Subject Re: [IBO] Connect To Firebird Over XP Peer to Peer
Author Helen Borrie
At 05:08 AM 8/05/2008, you wrote:
>I want to connect one client to a Firebird database located on a host
>machine that I access via an XP peer to peer connection. What's the
>correct way to setup the connection? I assume that I should use TCP\IP
>as the protocol? Hos should I set the server property and the database
>name?

Quick answer as I'm just about to leave for an overseas trip:

IB_Connection properties:

Server: hostname of server
Protocol: cpTCP_IP or cpNetBeui
Path: path to database as seen on the server machine (NOT a share or mapping of any sort) or (better) an alias name that is set up in aliases.conf on the host server

Password settings whatever you need

-- Clear out the Params property of the IB_Connection or IBODatabase
-- Clear the DatabaseName property and either enter a friendly name or let IBO write the property when it connects from the IDE

If you set cpTCP_IP as the protocol, IBO will use the connection string
hostname:d:\path\to\database\dbname.fdb
or
hostname:alias
If you set cpNetBeui, it will set
\\hostname\d:\path\to\database\dbname.fdb or \\hostname\alias

Don't confuse the Aliasname property with a Firebird alias. You must ignore that property.

And again, to reiterate, forget "peer to peer". That's a device-sharing layer that sits above the network layer and it's irrelevant to Firebird's client/server architecture.

You have 2 machines connected by a crossover cable. That's a network. Firebird clients use a network protocol. On Windows they have the choice of Netbeui (more correctly, Named Pipes or WNET) or TCP/IP. Generally WNET isn't recommended for larger networks because it's too noisy but for your 2-user setup, it might be the better choice.

Helen