Subject Re: ConnString for VFP works on and off (Connection handle is invalid.)
Author Bhavbhuti Nathwani
Hi Helen

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
> If you want to use an alias then you must define it in aliases.conf.

Yes, I have done that, this is the following aliases.conf from the FB server machine DEVE2
C17_37250 = "D:\PROGRAM FILES\VSO-CUSTOMIZED INV. & COMM. SYSTEM C17 C17-EXTRA\DATA\vso3.fdb"
C17_7202 = D:\PROGRAM FILES\VSO-CUSTOMIZED INV. & COMM. SYSTEM C17\DATA\vso3.fdb
C17_63844 = D:\PROGRAM FILES\VSO-CUSTOMIZED INV. & COMM. SYSTEM C17\DATA\abc\09-10\vso3.fdb
C17_33761 = "D:\PROGRAM FILES\VSO-CUSTOMIZED INV. & COMM. SYSTEM C17 C17\DATA\vso3.fdb"

> If you are using an alias, then make sure your application is consistent in using the alias wherever it refers to the path.

Yes that is enforced in the application as I have stored the alias in a property in the application object

>you run the risk of connection refusal (Superserver)

Hmm, how do I trip this? Maybe I have been tripping this off.

Now in my testing desperation setup the aliases.conf as above and have tried to connect to them one by one. The only one I have been able to successfully connect to is alias C17_7202 today (setup on Saturday after the failures), whereas on the preceding days I was successfully able to connect any of the other 3 aliases but one by one they started to close down on me. So as of today in quick succession I can only connect to C17_7202 but cannot the other 3 alias, so we can for the moment rule out networking issues as had it been the case I would not have been able to connect to any of them.

> Reserve the IP address for DEVE2 in the hosts file of the server ($windir\system32\drivers\etc\hosts) with the IP address of the host machine as it is seen by all of the clients, e.g.
>
> nnn.nnn.nnn.nnn DEVE2 #Host server for Firebird databases

okay thanks I will work on this line. Just to know more let's say the DEVE2 and it's dynamic IP is the issue here, will I have encountered a similar resolution problem for eg. UltraVNC, because I can consistently connect to DEVE2 to perform as a VNC server.

Thanks for your help. I hope I can give you more details but I am pretty lost right now not really seeing a pattern for the failures (expect the 'refusal' that you just mentioned).

Thanks again and regards
Bhavbhuti