Re: [firebird-support] FB on LAN
Hello Mark. I changed the firebird.conf by another one and restarted the server. Now my string connection 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB is working. I compared both firebird.conf and found two differences: 1) In the line near # Remove protection against opening databases on NFS mounted volumes on # Linux/Unix and SMB/CIFS volumes on Windows. that appears in original # ***WARNING*** ***WARNING*** ***WARNING*** ***WARNING*** in my firebird.conf the line was brioked, like # ***WARNING*** ***WARNING** * ***WARNING*** ***WARNING*** 2) There was difference in this line too, but the lines are commented. #CpuAffinityMask = 1 #CpuAffinityMask = 192 I am sure this could not cause problems, but the item 1 could? I think it is not pr Em 08/04/2016 04:12, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] escreveu: On 7-4-2016 20:54, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Hello Mark. > > I was like you showed 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB > > Than I changed from FB 32 to FB 64 and it stopped working. After that, > after that even turnning to FB 32 it doesn´t work using this structure. > I only works > using \\192.168.0.158\C:\DIR1\BASEDIR\MYDATABASE.FDB or > C:\DIR1\BASEDIR\MYDATABASE.FDB In your first question your connection string was: 192.168.0.158:\DIR1\BASEDIR\MYDATABASE.FDB Note the absence of _C:_ This means you are connecting with a relative path. And the root of this path depends on the configuration (and maybe on the user running Firebird). > I open the 3050 port in FW. But it keep not connecting. I just realised that you never specified the exact error you received. Can't you connect to Firebird at all? What error do you get? In that case it might be that it is 1) configured to use a different port (setting RemoteServicePort), 2) is blocked by the (Windows) firewall (make sure there is an exclusion for the process), 3) another process is running on port 3050, or 4) the firebird process is only listening on 127.0.0.1 (setting RemoteBindAddress). Mark -- Mark Rotteveel -- Atenciosamente, Hugo Eyng
Re: [firebird-support] FB on LAN
Hello Mark. I changed the firebird.conf by another one and restarted the server. Now my string connection 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB is working. I compared both firebird.conf and found two differences: 1) In the line near # Remove protection against opening databases on NFS mounted volumes on # Linux/Unix and SMB/CIFS volumes on Windows. that appears in original # ***WARNING*** ***WARNING*** ***WARNING*** ***WARNING*** in my firebird.conf the line was wraped, like # ***WARNING*** ***WARNING** * ***WARNING*** ***WARNING*** Em 08/04/2016 04:12, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] escreveu: On 7-4-2016 20:54, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Hello Mark. > > I was like you showed 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB > > Than I changed from FB 32 to FB 64 and it stopped working. After that, > after that even turnning to FB 32 it doesn´t work using this structure. > I only works > using \\192.168.0.158\C:\DIR1\BASEDIR\MYDATABASE.FDB or > C:\DIR1\BASEDIR\MYDATABASE.FDB In your first question your connection string was: 192.168.0.158:\DIR1\BASEDIR\MYDATABASE.FDB Note the absence of _C:_ This means you are connecting with a relative path. And the root of this path depends on the configuration (and maybe on the user running Firebird). > I open the 3050 port in FW. But it keep not connecting. I just realised that you never specified the exact error you received. Can't you connect to Firebird at all? What error do you get? In that case it might be that it is 1) configured to use a different port (setting RemoteServicePort), 2) is blocked by the (Windows) firewall (make sure there is an exclusion for the process), 3) another process is running on port 3050, or 4) the firebird process is only listening on 127.0.0.1 (setting RemoteBindAddress). Mark -- Mark Rotteveel -- Atenciosamente, Hugo Eyng
Re: [firebird-support] FB on LAN
Thank you Dimitry. I have this book. I will search. Bye Em 08/04/2016 10:29, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] escreveu: > 08.04.2016 15:17, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: >> Do you know where could I find information about string connections and >> protocols? > In "The Firebird Book: a Reference for Database Developers", for example. > -- Atenciosamente, Hugo Eyng ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ 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] FB on LAN
08.04.2016 15:17, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Do you know where could I find information about string connections and > protocols? In "The Firebird Book: a Reference for Database Developers", for example. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ 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] FB on LAN
Hello Mark. I changed the firebird.conf by another one and restarted the server. Now my string connection 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB is working. I compared both firebird.conf and found two differences: 1) In the line near # Remove protection against opening databases on NFS mounted volumes on # Linux/Unix and SMB/CIFS volumes on Windows. that appears in original # ***WARNING*** ***WARNING*** ***WARNING*** ***WARNING*** in my firebird.conf the line was brioked, like # ***WARNING*** ***WARNING** * ***WARNING*** ***WARNING*** 2) There was difference in this line too, but the lines are commented. #CpuAffinityMask = 1 #CpuAffinityMask = 192 I am sure this could not cause problems, but the item 1 could? I don´t think so. --- You told me something about using WNET protocol. Do you know where could I find information about string connections and protocols? Thank you for answering. Em 08/04/2016 04:12, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] escreveu: On 7-4-2016 20:54, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Hello Mark. > > I was like you showed 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB > > Than I changed from FB 32 to FB 64 and it stopped working. After that, > after that even turnning to FB 32 it doesn´t work using this structure. > I only works > using \\192.168.0.158\C:\DIR1\BASEDIR\MYDATABASE.FDB or > C:\DIR1\BASEDIR\MYDATABASE.FDB In your first question your connection string was: 192.168.0.158:\DIR1\BASEDIR\MYDATABASE.FDB Note the absence of _C:_ This means you are connecting with a relative path. And the root of this path depends on the configuration (and maybe on the user running Firebird). > I open the 3050 port in FW. But it keep not connecting. I just realised that you never specified the exact error you received. Can't you connect to Firebird at all? What error do you get? In that case it might be that it is 1) configured to use a different port (setting RemoteServicePort), 2) is blocked by the (Windows) firewall (make sure there is an exclusion for the process), 3) another process is running on port 3050, or 4) the firebird process is only listening on 127.0.0.1 (setting RemoteBindAddress). Mark -- Mark Rotteveel -- Atenciosamente, Hugo Eyng
Re: [firebird-support] FB on LAN
On 7-4-2016 20:54, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Hello Mark. > > I was like you showed 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB > > Than I changed from FB 32 to FB 64 and it stopped working. After that, > after that even turnning to FB 32 it doesn´t work using this structure. > I only works > using \\192.168.0.158\C:\DIR1\BASEDIR\MYDATABASE.FDB or > C:\DIR1\BASEDIR\MYDATABASE.FDB In your first question your connection string was: 192.168.0.158:\DIR1\BASEDIR\MYDATABASE.FDB Note the absence of _C:_ This means you are connecting with a relative path. And the root of this path depends on the configuration (and maybe on the user running Firebird). > I open the 3050 port in FW. But it keep not connecting. I just realised that you never specified the exact error you received. Can't you connect to Firebird at all? What error do you get? In that case it might be that it is 1) configured to use a different port (setting RemoteServicePort), 2) is blocked by the (Windows) firewall (make sure there is an exclusion for the process), 3) another process is running on port 3050, or 4) the firebird process is only listening on 127.0.0.1 (setting RemoteBindAddress). Mark -- Mark Rotteveel
Re: [firebird-support] FB on LAN
Hello Mark. I was like you showed 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB Than I changed from FB 32 to FB 64 and it stopped working. After that, after that even turnning to FB 32 it doesn´t work using this structure. I only works using \\192.168.0.158\C:\DIR1\BASEDIR\MYDATABASE.FDB or C:\DIR1\BASEDIR\MYDATABASE.FDB I open the 3050 port in FW. But it keep not connecting. Hugo Em 07/04/2016 11:45, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] escreveu: On 2016-04-07 14:41, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Hello. > > Thanks for answer my question. > > I changed the connection (Deplhi XE10 / DBX) to > \\192.168.0.158\C:\DIR1\BASEDIR\MYDATABASE.FDB and it works. With this change you are using a different protocol than you were using earlier. With this change you changed from the TCP/IP protocol to the WNET protocol, to continue to use the TCP/IP protocol, you should switch to: 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB Mark -- Atenciosamente, Hugo Eyng
Re: [firebird-support] FB on LAN
On 2016-04-07 14:41, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Hello. > > Thanks for answer my question. > > I changed the connection (Deplhi XE10 / DBX) to > \\192.168.0.158\C:\DIR1\BASEDIR\MYDATABASE.FDB and it works. With this change you are using a different protocol than you were using earlier. With this change you changed from the TCP/IP protocol to the WNET protocol, to continue to use the TCP/IP protocol, you should switch to: 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB Mark
Re: [firebird-support] FB on LAN
Hello. Thanks for answer my question. I changed the connection (Deplhi XE10 / DBX) to \\192.168.0.158\C:\DIR1\BASEDIR\MYDATABASE.FDB and it works. Em 06/04/2016 18:21, 'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support] escreveu: Have you checked the difference between the two Firebird.conf? You seem to be using relative paths to connect the database; I believe that depends on the RootDirectory setting. Mark - Bericht beantwoorden - Van: "Hugo Eyng hugoe...@msn.com [firebird-support]" Aan: Onderwerp: [firebird-support] FB on LAN Datum: wo, apr. 6, 2016 22:59 Hello. FB 2.5.5 32 bits SuperClassic installed on windows server 2008 Standard 64 bits Database: 192.168.0.158:\DIR1\BASEDIR\MYDATABASE.FDB working fine Then I changed to FB 2.5.5 64 bits SuperServer in the same server Database: 192.168.0.158:\DIR1\BASEDIR\MYDATABASE.FDB My connection to database stopped working. but Database: C:\DIR1\BASEDIR\MYDATABASE.FDB turned working Any hint? -- Atenciosamente, Hugo Eyng ++ Visithttp://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases athttp://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links -- Atenciosamente, Hugo Eyng
Re: [firebird-support] FB on LAN
Have you checked the difference between the two Firebird.conf? You seem to be using relative paths to connect the database; I believe that depends on the RootDirectory setting. Mark - Bericht beantwoorden - Van: "Hugo Eyng hugoe...@msn.com [firebird-support]" Aan: Onderwerp: [firebird-support] FB on LAN Datum: wo, apr. 6, 2016 22:59 Hello. FB 2.5.5 32 bits SuperClassic installed on windows server 2008 Standard 64 bits Database: 192.168.0.158:\DIR1\BASEDIR\MYDATABASE.FDB working fine Then I changed to FB 2.5.5 64 bits SuperServer in the same server Database: 192.168.0.158:\DIR1\BASEDIR\MYDATABASE.FDB My connection to database stopped working. but Database: C:\DIR1\BASEDIR\MYDATABASE.FDB turned working Any hint? -- Atenciosamente, Hugo Eyng ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links https://info.yahoo.com/legal/us/yahoo/utos/terms/