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 [email protected] [firebird-support] wrote: > Hi ! > > > Em 26/5/2014 21:17, Alan J Davies [email protected] > [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 > > > > ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
