Subject Re: Firebird 1.5.2 client on Win 2000
Author Tony Masefield
--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...>
wrote:
> --- In firebird-support@yahoogroups.com, "Tony Masefield"
> <polsolsa@y...> wrote:
> > Hi All,
> >
> > An update to the original post on this subject:
> >
> > When I initially copied the FDB file to the server from my
laptop I
> > had had to log on as the server administrator. After doing this
the
> > application on my laptop ran fine, even though the connection to
> the
> > server was disconnected/reconnected a few times.
> > When trying the app on the Win 2000 client it wouldn't work.
> > However, logging on to the server yesterday from the Win 200
> machine
> > as administrator, and then trying the app now works.
>
> Something in your app trying to write to HKEY_LOCAL_MACHINE?
>
No, it's a very simple app.

> > Obviously I'm missing something here in terms of the necessity
to
> > log onto the server in the first instance (the FDB is, BTW, in a
> > shared folder on the server).
>
> Argh,
>
> Get it out of the shared folder.
> Never share the folder with the fdb in it, apart from not being
able
> to connect to firebird over a share, it throws your security baby
out
> with the bath water.
>
Point taken but i put the FBDB in a shared folder as a temporary
measure as I wasn't suer if I would continue logging on as the
administrator. Too many people 'fiddling' with this server at
present it's a bit of a mess and I'm trying to keep out of it incase
(when!) something goes wrong.

> www.firebirdsql.org
>
> Download the Quick Start Guide
>
A good point. Went through lots of files/data and now you bring it
up I can't find the QSG! Didn't realise at the time that it was
missing. It was the first document on FB that I printed ( 2years
back?). Have now printed the 1.5 QSG and it's first in my FB data
file.

> It needs to be logged in if it is installed as an application, but
if
> it is installed as a service, then you can leave it logged out.
>
> Perhaps some other software is shutting down TCP or something
nasty
> like that in the BG.
>
> > Why logging on to the server just once should cause the app to
run
> > from that point forward I don't understand. I had assumed
> (obviously
> > wrongly) that setting the port at 3050 would bypass the server
log-
> > on requirements.
>
> It is running it as a service that bypasses the log on
requirements,
> I am guessing your environment is causing your troubles, not
Firebird.
>
FB runs OK on my PC in my flat as local (and also on the Win2003
server as connected to by my Laptop) so no, it's not a FB problem.
It's somewhere in the link between the clients and the server.

> > Actually, at the moment, the FDB is resident on the application
> > server which also runs a commercial Oracle based program (which
in
> > turn is connected to a DB server). The Oracle program is still
> > under "development/modification" (for the last 10 months) so I
am
> > trying to avoid any 'interference' with this aspect.
> > The one thing I haven't checked yet is what strain of Windows is
> > running on the application server at this time.
>
> The application server being the Firebird server? Check the
version
> as it may explain a few things.

It's FB version 1.5.1 and is running as a server on the Win 2003
server. the Guradian was 'on' but have turned it off today based on
re-reading the necessity of using the guardian on any platform other
than Win 9X and ME.
Didn't realise I had 1.5.1 on the server (put it there some months
ago). Will upgrade to 1.5.2 probably in the next week. Programming
is more of a hobby than anything else right now so I have other
pressures (running the technical, production, maintenance and drum
reconditioning departments) that have been neglected for some years.

Regards and thanks for your help thus far!