Hello:

I am trying to troubleshoot a problem for a Delphi / InterBase
application that is running on a Win2k network. I did not write the
app, and there is very little setup and configuration information for
me to rely on. What I do know is included below:

---------------------------
Application Design

· InterBase6 Server
· Borland Delphi Application
· App is a maintenance management database

Application Configuration

· Server

o InterBase6 Server installed on Win2k Server, default location
o Server-side components, including client app (.exe) installed
on Win2k Server, on applications drive, which is different than the
OS volume; One folder above the App install folder is shared
o InterBase6 database server file (GDB) is located on the same
drive as the app, but in a different folder
o Client components, including InterBase6 Client, installed on
client PCs
o All clients use identical (SYSDBA) login to database server
(GDB) <I didn't do it that way, not my call>
o Certificates in place for 25 simultaneous users

· Clients

o Users authenticate on corporate domain; user's rights are
propagated via domain; no local profiles on Win2k Server
o Client domain profiles given change permissions (Power Users)
to App folder on Win2k Server, but no other access on the Server
o Client PCs have shortcut to app executable… located on the
Win2k Server
o Clients have mixed rights on their local PCs, but mostly
restricted to standard users
o All client path access to app executable via UNC only, no
mapped drive
o BDE and ODBC (for Crystal Reports) paths to GDB file also use
UNC

Problem

· Clients can execute the app, but a SQL error is returned when
loading data from the database server, indicating no connectivity to
the GDB

Error Message <Title: Database Connection Error>

<Red 'X'>
Unknown database.
I/O error for file "\CMMS\DBApplication\Database\DATABASE.GDB"
Error while trying to open file
The system cannot find
General SQL error.
the path specified.
Alias: DATASOURCE
Error in connecting with database server.
Contact Administrator

Additional

· IBConsole works as expected, allowing login and access to
database server. Database is all there and working as expected
through IBConsole
· The identified problem seems to be something with InterBase
and the clients, such as the clients somehow can't "talk" to
InterBase services as expected
· A very similar configuration in my test lab works perfectly,
with the following differences:

o My lab is a standalone workgroup
o User profiles exist on the Win2k Server
o Members of the group with access to the app have "Power User"
rights in general on the Win2k Server
o Clients have Admin rights on the Client PCs
------------------------

I apologize for the format of the specifics... pasted in from a Word
doc.

Any ideas?

Many thanks!

-Gary