Subject Re: [firebird-support] Re: localhost connection is broken
Author Hans
Something wrong, never expected your messages here flagged by Shaw as
suspected junk mail :)

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <firebird-support@yahoogroups.com>
Sent: Saturday, September 03, 2005 9:16 PM
Subject: Re: [firebird-support] Re: localhost connection is broken


> At 01:46 AM 4/09/2005 +0000, you wrote:
>>Just a reminder. This is on a Windows XP Pro PC.
>>
>>Ping localhost resolves to 127.0.0.1, which is my PC. No other PC is
>>on the network.
>>
>>I can connect with ISQL but I am not sure how to specify localhost.
>>The way I am connecting is CONNECT <path> user sysdba password
>>masterkey.
>
> Here you are doing a "Windows local" connection. It does not use a
> network
> protocol.
>
> Localhost is not the same thing: it is an emulated network connection, to
> the TCP/IP local loopback server. Try a lls connection with isql, as
> follows:
>
> SQL>CONNECT 'localhost:drive:\path\to\database\file' user 'sysdba'
> password
> 'masterkey';
>
> [where "drive" is the actual drive name as seen on the server, not a share
> or a mapping of any sort]
>
> -- note the quotes on the strings. Note also that the connection string
> will require double-quotes if there are any spaces in the path name.
>
> Of course, if you are using FbEmbedded, then you can not use any sort of
> network protocol for the connection....ONLY Windows local will work.
>
> However....do I recall correctly that the original problem you reported
> was
> that IBConsole complained it "could not connect to Services manager"?
> This
> is a different problem since, unlike isql, IBConsole is a front-end to the
> Services API.
>
> If you are running Firebird Classic, IBConsole will return this error
> because IBConsole was written for InterBase. InterBase doesn't have a
> Windows Classic version; and any IBConsole exe that was compiled by
> Borland is hard-coded to reject a connection to anything but
> Superserver. (It won't connect to a Classic server on a Linux host,
> either.)
>
> I believe this limitation was inherent in the early version of IBOConsole,
> too, but was fixed later, to take account of the fact that some aspects of
> the Services API were implemented for Fb 1.5 Classic. You might want to
> consider visiting www.mengoni.it, and downloading the most recent
> IBOConsole executable.
>
> ./heLen
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>