I may have a Server on a different machine than the client(s).  Thats not a
problem, obviously.

However, the Server may be on the dreaded Vista.  Of course, I can install
the server in program files or if need be Common Application Data directory.

The Configuration file would point to the Common Application Data subfolder
to save the settings and be read/writable.

Now the question becomes creating a database.  I may not know that its the C
drive that Windows was installed, even though that would cover 98% of the
time.  But I need to save the database in a read/write location that plays
well with Vista.   So again, Common Application Data folder would be good.
Of course, the other problem is that I may not know what OS the server is
installed on.

What would be the proper way to set up the SQL statement to create database?

Lance

Lance,

<< What would be the proper way to set up the SQL statement to create
database? >>

Since the database creation is usually called from within the application
directly because it's the first step in the process, just build the CREATE
DATABASE statement as necessary using the desired path for the database
directory.

--
Tim Young
Elevate Software
www.elevatesoft.com