Thanks Alexandre, that's exactly it.
I'm using a test setup of just 2 computers that I have not used for a
while and had not checked. It works perfectly as I guess you knew it would!
I still have a text file of Server_Name.Txt that just contains
"ajd-sony" which is hidden, read-only, so I'm not worried about that.
I then load that from file and set
DataBaseName:=Server_Name+':'+DataBaseName
That works locally and from remote computer.

Thanks for your help.
Regards
Alan

Alan J Davies
Aldis


On 27/05/2014 01:57, Alexandre Benson Smith iblist@...
[firebird-support] wrote:

> Hi !
>
>
> Em 26/5/2014 21:17, Alan J Davies Alan.Davies@...
> [firebird-support] escreveu:
>> I'm trying to do that exactly but cannot make it work.
>> I'm using Win7, FB 2.5.1 on host (server) and Win7 on client.
>> The application is running in Delphi XE2 and works perfectly on host &
>> client when I do the following (as I have since Delphi5):
>>
>> In the application folder I have the database, the application, plus a
>> text file called App_Data.Txt with the following line:
>>
>> //AJD-SONY/C:/APPS/PJSMOULDINGS/ORDERS.FDB
>>
>> I load this file and set the database name to it - then open the
>> database and it all works as it should.
>>
>> Now I try and replicate the example below from Helen et al.
>>
>> On the server I have this in my aliases.conf
>> PJSMOULDINGS=C:\DATABASES\PJSMOULDINGS\ORDERS.FDB
>>
>> I also set PJSMOULDINGS as the DataBaseName in the Delphi app itself and
>> this works on the server without loading App_Data.Txt
>> Also if I set the database name to 'AJD-SONY:'+PJSMOULDINGS, it works.
>>
>> But not on the client.
>> The error I get after 2-3 minutes is "Unable to complete network request
>> to host "AJD-SONY". Failed to establish a connection ....."
>> The program loads but database is unavailable.
>> This is regardless of whether using a mapped drive or a shortcut.
>>
>> Any help would be appreciated. So far my own method has worked without a
>> hitch, but sooner or later ........
>> Regards
>> Alan
>>
>> Alan J Davies
>> Aldis
>>
>
> I think you have the TCP/IP port 3050 closed on the host machine.
>
> Check the windows firewall
>
> In the first example you are not using a TCP/IP conection.
>
> see you !
>
>
>
>
> ------------------------------------
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo Groups Links
>
>
>
>