Thanks for the reply and I wouldn't consider my self an expert with databases.  I have worked on teams responsible for database design and have done some small to somewhat complex queries, triggers and such.  My recomendation to the client is that they store all of there data in a centralized database using a client server database.  But all of there data, some of which wont be moved to the database is stored on shared network drives where the path to the files contains information pertinant to the data.  That and there back up process was developed in such a manner to work with the network directories.  They know that there system doesn't work but want to make the most simplisest of changes to the process as possible.  Right now they have some data stored in large XML files in the directories which have become a bear to handle so they want me to move the data into database files, I'm still not sure they even know what they mean by database
files.  I could think of a lot of reason why it shouldn't be down but none as to why it couldn't be done.  My skills are more system's development C, C++ etc my work with database has been enough just to get the job done.
 
John
 


________________________________
From: Helen Borrie <helebor@...>
To: firebird-support@yahoogroups.com
Sent: Monday, September 17, 2012 4:08 PM
Subject: Re: [firebird-support] Number of instances of firebird


 
At 05:34 AM 18/09/2012, John Wilk wrote:

>Hi all I have a client who has software wich runs a test in which the software collects data. What my client would like to do is be able to store each test's data in an independent database located on a network share.

Not on a network share...that is not supported by Firebird for read/write databases. Firebird server is a database management system that lives on a host server and manages one or more databases on the same physical host. Clients, such as your data-collecting application, attach to a database across a network, using a network protocol.

In theory, there's no reason why each test couldn't have its own database. In practice, why should that be necessary? What is special about the requirements, that sets of results need to be isolated from one another? Does your customer understand the differences between a table and a database? Does [s]he really want to be administering multiple databases unnecessarily?

> This is a little beyound me and something I had never really thought about if anyone has any info or suggestions where I could look for info.

It's not clear whether you are already a database developer yourself. If you haven't worked with client/server systems before, a good place to start would be the Quick Start Guide for the version of Firebird that you are using. You can find it in the \doc\ directory of a standard Firebird server installation; otherwise you can pick it up from the documentation pages at the Firebird website.

My books (latest version The Firebird Book Second Edition) devote quite a lot of space to explaining how the various client/server models work. If you feel you need that, visit http://www.ibphoenix.com/products/books/firebird_book and consider buying the Developer DVD, on which it is distributed.

./heLen




[Non-text portions of this message have been removed]