Subject | Re: [ib-support] SQL Error Accessing Database Server (GDB) |
---|---|
Author | Helen Borrie |
Post date | 2003-06-12T16:01:25Z |
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
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