Subject Re: [firebird-support] Re: Embedded database with multiple users...
Author Helen Borrie
At 09:27 PM 11/05/2005 +0000, you wrote:
>--- In firebird-support@yahoogroups.com, Elmar Haneke <elmar@h...>
>wrote:
> >
> > I have no experience with classic. But, running SuperServer as an
> > application is not a Problem at all - just run the fbserver.exe.
> >
> > Elmar
>
>
>So I don't actually have to install it? Just run the fbserver.exe?
>There has to be more to it than that.

Of course there is. FbServer.exe is the server program. It uses all of
the other pieces of the installation, just as the Embedded superserver
does. The only differences are that client apps connect through the client
part of the engine on its own, rather than through the same code that is
rolled together with the server part of the engine; and the full server
version is protected by security authentication.

FbServer can be installed to run as a service or as an application. It's
the same executable: the difference is in whose application space the code
runs. To be run as an application, it has to be started by a logged-on user.

>How do I create the db?

The same way as you create it via embedded. It's the same software.

>How do I connect to it?

Locally, the same way, though with the same restrictions. You can also
connect locally through the TCP/IP local loopback server, a.k.a. localhost,
with the IP address 127.0.0.1. From remote clients, the connection code is
the same, except that the hostname and port are in the connection
string. Exactly how those are expressed depends on the network
protocol. You can study the details in the v.1.5 release notes, in the
section titled "Configuring the port service on client and
server". However, if your installation is able to use the default port
(3050) because there is no other installation of Firebird or InterBase
present and no other app on the service is already using it, it's simpler
than that.

>It looks like this may be my only option

For multi-user, yes. Win95, Win98, WinME and WinXP Home servers can *only*
run the server as an application. For other Windows versions, it is a lot
more robust to run it as a service. You should have no problem in your
installer with recommending this if the installation is going onto a server
that supports services.

>, so if someone could give me
>a breakdown of how to use SS as an application and create/connect to
>a database it would be much appreciated.

It seems as if you need to do quite a bit more reading. You could begin by
downloading the Quick Start Guide. There are links to in several places
around the Firebird website (www.firebirdsql.org), including the Novices
Guide section, which would be a good place for you to visit anyway.

./heLen