Subject | Re: [firebird-support] Embedded Database from server share. |
---|---|
Author | S C |
Post date | 2006-01-13T18:05:26Z |
Using the embedded server with the config file. I cannot seem to make it
work.
I have the dB, fbembed.dll, and the firebird.conf with only this
RemoteFileOpenAbility = 0 all in the same dir. It still will not connect. Am
I missing something?
work.
I have the dB, fbembed.dll, and the firebird.conf with only this
RemoteFileOpenAbility = 0 all in the same dir. It still will not connect. Am
I missing something?
>From: "Ann W. Harrison" <aharrison@...>
>Reply-To: firebird-support@yahoogroups.com
>To: firebird-support@yahoogroups.com
>Subject: Re: [firebird-support] Embedded Database from server share.
>Date: Thu, 12 Jan 2006 15:59:41 -0500
>MIME-Version: 1.0
>X-Originating-IP: 12.197.12.134
>X-Sender: aharrison@...
>Received: from n23.bullet.scd.yahoo.com ([66.94.237.52]) by
>bay0-mc10-f16.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Thu,
>12 Jan 2006 12:53:41 -0800
>Received: from [66.218.69.3] by n23.bullet.scd.yahoo.com with NNFMP; 12 Jan
>2006 20:53:17 -0000
>Received: from [66.218.66.35] by t3.bullet.scd.yahoo.com with NNFMP; 12 Jan
>2006 20:53:15 -0000
>Received: (qmail 8963 invoked from network); 12 Jan 2006 20:53:12 -0000
>Received: from unknown (66.218.66.172) by m29.grp.scd.yahoo.com with QMQP;
>12 Jan 2006 20:53:12 -0000
>Received: from unknown (HELO firebird.netfrastructure.com) (12.197.12.134)
>by mta4.grp.scd.yahoo.com with SMTP; 12 Jan 2006 20:53:12 -0000
>Received: from [127.0.0.1] ([12.197.12.137])by firebird.netfrastructure.com
>(8.12.8/8.12.8) with ESMTP id k0CIrwsP001680for
><firebird-support@yahoogroups.com>; Thu, 12 Jan 2006 13:54:00 -0500
>X-Message-Info: JGTYoYF78jEHjJx36Oi8+Z3TmmkSEdPtfpLB7P/ybN8=
>Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys
>DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=lima;
>d=yahoogroups.com;b=aD8Za+ZWpQuTVfqipMuXyW4cDrAVLPG/E5IfO7uySdB3Nb21M/hx3X7cU/IeqljQ49/2QBiXelGrzTz1D0e5+UsjrbHASHb6enCZ/dqtfOspDVLnB4LewNhlFQC2LX6N;
>X-Yahoo-Newman-Property: groups-email
>X-Apparently-To: firebird-support@yahoogroups.com
>User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
>X-Accept-Language: en-us, en
>References: <BAY101-F36CEB0449E5E52C78EB827FF270@...>
>X-eGroups-Msg-Info: 1:12:0:0
>X-Yahoo-Profile: annwharrison
>Mailing-List: list firebird-support@yahoogroups.com; contact
>firebird-support-owner@yahoogroups.com
>Delivered-To: mailing list firebird-support@yahoogroups.com
>List-Id: <firebird-support.yahoogroups.com>
>Precedence: bulk
>List-Unsubscribe: <mailto:firebird-support-unsubscribe@yahoogroups.com>
>Return-Path:
>sentto-2442406-71034-1137099194-pc_phd=hotmail.com@...
>X-OriginalArrivalTime: 12 Jan 2006 20:53:41.0683 (UTC)
>FILETIME=[45127030:01C617BA]
>
>S C wrote:
> > The problem is that I cannot setup a server in the work environment to
>host
> > the firebird server. My PC is not always going to be on. So installing
>the
> > server there would not be stable enough. It just seem to me that
>embedded
> > should work on any drive type. Why does it matter if its a network
>drive.
>
>Because if you happen to open the same database from two different
>embedded engines on two different PC's, they'll trash the database.
>And, as far as I know, the second PC has no reliable way of knowing
>that the file has been opened elsewhere. If we had a reliable way
>of identifying conflicts, we would allow connections to files on
>shared drives. Without that, there's too much risk. However, if
>you really like living on the edge, here's the parameter - and
>warning - from the configuration file.
>
># ----------------------------
># Remove protection against opening databases on NFS mounted volumes
>#
># ***WARNING*** ***WARNING*** ***WARNING*** ***WARNING***
>#
># This option removes an important safety feature of Firebird and can
># cause irrecoverable database corruption. Do not use this option unless
># you understand the risks and are prepared to accept the loss of the
># contents of your database.
># Unless this configuration option is changed from 0 to 1, Firebird can
># open a database only if the database is stored on a drive physically
># attached to the local computer � the computer running that copy of
># Firebird. Requests for connections to databases stored on NFS mounted
># drives are redirected to a Firebird server running on the computer that
># "owns" the disk.
># This restriction prevents two different copies of Firebird from opening
># the same database without coordinating their activities. Uncoordinated
># access by multiple copies of Firebird will corrupt a database. On a local
># system, the system-level file locking prevents uncoordinated access to
># the database file.
># NFS does not provide a reliable way to detect multiple users of a file on
># an NFS mounted disk. If a second copy of Firebird connects to a
>database on
># an NFS mounted disk, it will corrupt the database.
># Under some circumstances, running a Firebird server on the computer that
># owns NFS mounted volumes is inconvenient or impossible. Applications that
># use the "embedded" variant of Firebird and never share access to a
>database
># can use this option to permit direct access to databases on NFS mounted
># volumes.
># DO NOT ENABLE THIS OPTION UNLESS YOU REALLY KNOW WHAT YOU ARE DOING.
>#
># Type: boolean
>#
>#RemoteFileOpenAbility = 0
>
>
>Regards,
>
>
>Ann
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>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
>
>
>
>
>
>