Subject Re: [ib-support] SQL Error Accessing Database Server (GDB)
Author Helen Borrie
Gary,
At 03:22 PM 12/06/2003 +0000, you wrote:
[snip]

I/O error for file "\CMMS\DBApplication\Database\DATABASE.GDB"

This path won't find the database. Assuming "CMMS" is the host name, and
the the absolute path to the database file (as seen from the host ONLY) is
D:\DBApplication\Database\DATABASE.GDB

then the clients' connection string must be either

\\CMMS\D:\DBApplication\Database\DATABASE.GDB (for NetBEUI clients)

or

CMMS:D:\DBApplication\Database\DATABASE.GDB (for TCP/IP clients)

But, I suspect that CMMS is NOT the host name of the server, but the name
of a share. In your description, you said:

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

This conflicts with what the in-error connection string indicates. The
database file is apparently beneath the application root, on a share. The
database file cannot be accessed through a share. Period.

Did the database connectivity *ever* work?

heLen