Subject Re: [firebird-support] PROGRAMDATA Error while trying to write to file
Author Peter Morris [Air Software Ltd]
Hi Helen


> With embedded the database can't be shared. Embedded is a special model
> that runs a single instance of the Superserver for the exclusive use of
> the client instance that it is embedded with. So, while that
> client/server instance pair has a database open, no other client or server
> can access that database.

There has been a misunderstanding. The DB will be used on a single PC which
is a single-user version of windows. Multiple people might log into the
computer under different logins but only one person will be using it at a
time. What I mean by "shared by multiple people" is that each person who
uses the computer will see the same database and not personal copies, but
only one user accessing the DB at a time.

Please re-read my post with this in mind. My problem is that I do not seem
to be able to access the database if it is in the c:\ProgramData folder on
Vista. Putting it in UserData works fine, but that would mean each user
sees their own copy of the database. It is imperative that any user logging
in sees the same data.

Is there a problem with embedded fb using a GDB in this folder on vista? I
can write files to that folder using a .NET file stream class but embedded
FB wont work for me. Any information you have that might help will be
greatly appreciated, I have to train someone with the software tomorrow
(Vista) and provide an installation on Friday :-S


Pete