Re: [firebird-support] Aliases and Windows Host - any
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 ibl...@thorsoftware.com.br [firebird-support] wrote: Hi ! Em 26/5/2014 21:17, Alan J Davies alan.dav...@aldis-systems.co.uk [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: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com * Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Aliases and Windows Host - any
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 On 30/05/2013 20:45, Helen Borrie wrote: At 11:35 p.m. 30/05/2013, Norman Dunbar wrote: Q3. Are you connecting locally (on the database server) or remotely? If locally, then the alias.conf should simply be as above, the path to the database. if remotely, then your own aliases.conf (assuming that exists in a client only install - I've never done one!) will need to have the server name as well: employee = win7_server:employee employee.fdb = win7_server:employee In this case, your local employee aliases connect to the server and use the server's employee alias. The above (colon separator) assumes TCP protocol. Norm, this isn't correct. Aliases.conf doesn't belong in a client-only install at all. The paths in aliases.conf are strictly file system paths that are local to the Firebird host machine. No hostnames in aliases.conf, ever! What you need to do: 1. Move the database file right out of the Users tree and into a directory that is not protected by Windows (see Mark's list). That is, create a directory named c:\dati (as you had on W2003) and put your databases in their own subdirs under this. Do NOT make it a share. 2. Fix aliases.conf *in your Firebird host root directory*: entries should look like this: XFILES = C:\DATI\FB\XFILES.FDB 3. Check to make sure port 3050 is open in the host's firewall. 4. Make sure remote clients connect using the correct hostname, e.g., using Norm's example, win7_server:XFILES Helen Borrie, Support Consultant, IBPhoenix (Pacific) Author of The Firebird Book and The Firebird Book Second Edition http://www.firebird-books.net __ ++ 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: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com * Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Aliases and Windows Host - any
Hi ! Em 26/5/2014 21:17, Alan J Davies alan.dav...@aldis-systems.co.uk [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 * 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: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com * Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/