Hi all,

this is a follow-on to the previous topic
http://groups.google.com/group/comp....7d75a7403 071
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....7d75a7403 071
> 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
>

I tried sending you a copy of ersched (sql editor) but it got rejected.
Sorry.


"Joachim Klassen" <JoKlassen@email.com> wrote in message
news:1147170074.938424.45230@y43g2000cwc.googlegro ups.com...
> Hi all,
>
> this is a follow-on to the previous topic
>
http://groups.google.com/group/comp....7d75a7403 071
> 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
>