HDR and Cleint redirection - How to do with setnet32 ?
Hi all, this is a follow-on to the previous topic http://groups.google.com/group/comp.databases.informix/browse_frm/thread/c2a98fb2b3aadd3/80977d75a7403071?q=hdr+client&rnum=1#80977d75a7403071 First, thanks to all for your help. You showed me that a sqlhosts like the following will be usable for automatic client redirection to servers in a HDR Cluster sqlhosts file: myServer group - - myServer1 onsoctcp myHost1 myPort1 g=myServer myServer2 onsoctcp myHost2 myPort2 g=myServer But now how do I setup the sqlhosts on windows xp with Informix Connect 2.90 ? setnet32 doesn't allow to specify the value "group" for the protocolname. So i changed the registry manually. But when i try to test the connection with the "ILogin Demo" tool it gives a -25555 error when i use the groupname myServer as servername. If I use myServer1 it works. I have seen threads mentioning a tool ershed.exe which can copy a UNIX sqlhosts into the Win registry but I do not have ershed.exe on my client installation. Any hints ? TIA Joachim
Joachim Klassen wrote: > Hi all, > > this is a follow-on to the previous topic > http://groups.google.com/group/comp.databases.informix/browse_frm/thread/c2a98fb2b3aadd3/80977d75a7403071?q=hdr+client&rnum=1#80977d75a7403071 > First, thanks to all for your help. > > You showed me that a sqlhosts like the following will be usable for > automatic client redirection to servers in a HDR Cluster > > sqlhosts file: > myServer group - - You've missed out the 'e' option: myServer group - - e=myServer2 > myServer1 onsoctcp myHost1 myPort1 g=myServer > myServer2 onsoctcp myHost2 myPort2 g=myServer > > But now how do I setup the sqlhosts on windows xp with Informix Connect > 2.90 ? setnet32 doesn't allow to specify the value "group" for the > protocolname. So i changed the registry manually. But when i try to > test the connection with the "ILogin Demo" tool it gives a -25555 error > when i use the groupname myServer as servername. If I use myServer1 it > works. I have seen threads mentioning a tool ershed.exe which can copy > a UNIX sqlhosts into the Win registry but I do not have ershed.exe on > my client installation. > > Any hints ? > > TIA > Joachim >