Helen Borrie wrote:

>At 11:54 PM 11/04/2005 +0000, you wrote:
>
>
>
>
>>this is what my client PC gets when it attempts to run the app on the
>>server. what's weird is the client PC works fine, if the server opens
>>the database first. I really am trying to figure this out by myself
>>and I've about reached my wits' end. Even just a hint would be
>>appreciated. This is a continuation of an earlier message I posted,
>>so I won't repeat all that stuff again.
>>
>>
>
>The password database is the security database. In Fb 1, it's name is
>isc4.gdb. In Fb 1.5, it is security.fdb. In answer to the subject, yes,
>that error has been seen before. :-) Now your mission is to give us
>adequate information to work out why *you* are seeing it.
>
>We did rather get the details of your setup in disconnected bits and pieces
>first time around. In any case, old threads quickly scroll off the radar.
>
>Begin by telling us ALL of the following:
>
>What version of Fb you are using and the *exact* platform it is running on
> --------------------
>Which model (Superserver or Classic).
> --------------------
>The connection string that the remote client is using to connect to the
>database.
> --------------------
>What version string is reported for the client library on the remote client
>(by studying the property sheet of the DLL).
> --------------------
>The exact path location of the Firebird installation on the server, e.g.
>"C:\Program Files\Blah...."
> --------------------
>The exact, ABSOLUTE path location of the database on the server (don't give
>us any share names, mapped servers, UNC names, etc.)
> --------------------
>Anything else pertinent to the network connection between the remote client
>and the server - like what happens when you ping the host machine by name
>from the remote client machine, etc.
> --------------------
>
>./heLen
>
>
>Yahoo! Groups Links
>
>
>
>
>
>

Q: What version of Fb you are using and the *exact* platform it is running on
A: FB1.5.2 4731 Superserver on XP Pro

Q: The connection string that the remote client is using to connect to
the database.
A: \\NSTI-2\C:\Program Files\AT6TestData (NSTI-2 is the server's
computer name.)

Q: What version string is reported for the client library on the remote client
(by studying the property sheet of the DLL).
A: File Version: 1.5.2.4731

Q: The exact path location of the Firebird installation on the server
A: C:\Program Files\Firebird\Firebird_1_5 (This is where Security.fdb
is located.)

Q: The exact, ABSOLUTE path location of the database on the server
A: C:\Program Files\AT6TestData

Pertinent Info?:
The client PC (NSTI-8) is executing \\NSTI-2\C\AT6TestApp\program name.exe, which it has full rights to.
The "C" between the two back slashes is a Workgroup share name.
The app attempts to connect to two ODBC data sources, each defined in the connectionstring property of a Delphi 7 ADOConnection object in a datamodule.

I use the following syntax to open each database on the formCreate method of the mainform.
if not db.active then
db.open;
I create the data module where each ADOConnection object resides just prior to the open statements.
This works fine when I execute the app on the server.
Not so when I execute the app remotely from the client.

Thx again.
Sam Hunt