Informix

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

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
------------------------------

Original Message:
Sent: Mon October 19, 2020 07:11 AM
From: Øyvind Gjerstad
Subject: 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

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
------------------------------

Original Message:
Sent: Mon October 19, 2020 07:43 AM
From: Sheshnarayan Agrawal
Subject: ODBC connection to group (of connection managers)

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

Original Message:
Sent: Mon October 19, 2020 07:11 AM
From: Øyvind Gjerstad
Subject: 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

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
------------------------------

Original Message:
Sent: Mon October 19, 2020 07:56 AM
From: Øyvind Gjerstad
Subject: ODBC connection to group (of connection managers)

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

Original Message:
Sent: Mon October 19, 2020 07:43 AM
From: Sheshnarayan Agrawal
Subject: ODBC connection to group (of connection managers)

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

Original Message:
Sent: Mon October 19, 2020 07:11 AM
From: Øyvind Gjerstad
Subject: 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

Original Message:
Sent: 10/19/2020 7:11:00 AM
From: Øyvind Gjerstad
Subject: 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

@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
------------------------------

Original Message:
Sent: Mon October 19, 2020 08:44 AM
From: Art Kagel
Subject: ODBC connection to group (of connection managers)

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.

Original Message:
Sent: 10/19/2020 7:11:00 AM
From: Øyvind Gjerstad
Subject: 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

Yup, sure have.

------------------------------
Art Kagel
------------------------------

Original Message:
Sent: Tue October 20, 2020 09:45 AM
From: TOM GIRSCH
Subject: ODBC connection to group (of connection managers)

@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

Original Message:
Sent: Mon October 19, 2020 08:44 AM
From: Art Kagel
Subject: ODBC connection to group (of connection managers)

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.

Original Message:
Sent: 10/19/2020 7:11:00 AM
From: Øyvind Gjerstad
Subject: 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

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
------------------------------

Original Message:
Sent: Mon October 19, 2020 07:11 AM
From: Øyvind Gjerstad
Subject: 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