ODBC connection to group (of connection managers)

Hi, I have somewhat limited experience with ODBC (or Windows, for that matter). We have two connection managers providing access to our cluster of Informix database servers. From Unix and/or JDBC we are using sqlhosts to create groups of connection managers for this setup. I am struggling with finding good information for this setup with ODBC (from Windows). Some of the suggested solutions involve first creating a normal connection to a informix host (or one of the connection managers), and then modify that with regedit. Is this really still required?? Thanks in advance, ------------------------------ Øyvind Gjerstad Developer/Architect PostNord AS ------------------------------ #Informix

| view attached Hi Gjerstad, I am attaching the relatively old document which describes step by step setup of connection manager and CSDK/ODBC connection information. Please let me know if need more information. Hope the document will help Thanks -Shesh ------------------------------ Sheshnarayan Agrawal ------------------------------

Thanks a lot for answering, but I could not find a description on how to configure connection to a group of connection managers in the attached document. We have the database servers and the connection managers running (on Linux) for many years, they work just fine, but for the ODBC connections from Windows we have only enabled one of the connection managers, not the group, so we are not utilizing multiple connection managers, and if this connection manager for some reason is down, the ODBC connection will not work currently. ------------------------------ Øyvind Gjerstad Developer/Architect PostNord AS ------------------------------

Hi Gjerstad, The document I shared uses only "single connection manager with multiple servers". I haven't tried "multiple connection managers", however following the document (from page #9 onward), you should be able to modify/configure the same for "multiple connection managers". What you use on Linux/Unix as sqlhosts file, on Windows you have "Setnet32" utility to configure(sqlhosts file) the connection details for CSDK/ODBC(applications) on Windows. Thanks -Shesh ------------------------------ Sheshnarayan Agrawal ------------------------------

You need to create a group in the windows registry that names the connection names for the two connection managers. You should also enter the group and the connection managers' details in the sqlhosts file on the machine. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

In our environment, we worked around this issue via use of an F5. We created a virtual server on the F5 that forwards connections to the connection managers in a round-robin fashion. Then the ODBC setup is as simple as pointing the connection to the F5 virtual server, which does all the load balancing and failover for the CMs. As an added bonus, we were able to work around a problematic legacy app that connected to a decommissioned port by doing a port translation at the F5 level. ------------------------------ TOM GIRSCH ------------------------------

@Art Kagel You've been answering this question for a LOOOOONG time. ;) https://members.iiug.org/forums/ids/index.cgi/noframes/read/30448 ------------------------------ TOM GIRSCH ------------------------------

Yup, sure have. ------------------------------ Art Kagel ------------------------------