--- In ib-support@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> 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

Yes, it works just fine in the lab.

A bit of clarification...

The string supplied to the connection path specifier the very first
time a client runs the app and connects to the database is the UNC
path to the GDB file. That gets translated to look like the following
in the BDE and ODBC entries:

"Cnv-eng-lab-si1:\CMMS\AppServer\Database\DATABASE.GDB"

That's in the lab. "Cnv-eng-lab-si1" is the name of the Win2k Server;
CMMS is the share; \AppServer\Database\DATABASE.GDB is the path to
the database server file.

The colon in the path (the translation of the string) appears to be
created by the connection path tool (specifier for lack of a better
word) the very first time the app is run.

These are TCP/IP only environments in both cases.

Does that help?

Thanks again,
-Gary