IDS Forum

Re: connection issues on 12.10 32bit

Posted By: BillHatVerizon
Date: Wednesday, 17 July 2013, at 6:30 p.m.

In Response To: RE: connection issues on 12.10 32bit (Justin Killen)

it is 64bit windows and 32 bit informix and 32bit odbc driver.
Been doin it for years.

-----Original Message-----
From: Justin Killen
Sent: Wednesday, July 17, 2013 12:41 PM
To: ids@iiug.org
Subject: RE: connection issues on 12.10 32bit [30875]

You mention wow6432node, but that key is only for 64-bit systems. Are you
saying that the server is a 64-bit OS, and you're trying to setup the 32-bit
drivers for use with a 32-bit program?

--Justin
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
BillHatVerizon
Sent: Friday, July 12, 2013 6:53 PM
To: ids@iiug.org
Subject: connection issues on 12.10 32bit [30835]

This concerns IDS 12.10.TC1IE on Windows server 2008 R2.
I find that c# programs using IfxConnection fail to connect unless the
INFORMIXSQLHOSTS environment variable is set to the server name or deleted
entirely.
But that stops dbschema, dbaccess, etc from running.
The registry was setup correctly under wow6432node by the Informix install.

I have to set informixsqlhosts=C:\informix\etc\sqlhosts.mystiq to get
informix
utilities to run
and "set informixsqlhost=" to get c# programs to connect.
Wow! that is inconvenient.
This problem started with 12.1 .

Also ODBC got broken in 12.1. Connections are slow to happen, but they
connect
eventually.
I don't know if this could relate to the .net problem, but the connection is
on an ODBC provider..
Tracing reveals this:

--------------------------------------------------------------------------------
error code -11073

Option type out of range.

This IBM Informix CLI error code is the same as SQLSTATE value S1092.
The following functions can return this error code: SQLFreeStmt(),
SQLGetConnectOption(), SQLGetStmtOption(), SQLSetConnectOption(), and
SQLSetStmtOption().

The value specified for the argument fOption is in the block of numbers
reserved for CLI connection and statement option but is not valid for the
version of ODBC that the driver supports.
For a list of accepted descriptor types, check the IBM Informix CLI
Programmer's Manual.

The fOption argument was not a valid option value. Set fOption to a valid
value.
the driver version is 4.10.00.15184

--------------------------------------------------------------------------------

Anyone have either experience and find solutions?

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• connection issues on 12.10 32bit
  BillHatVerizon -- Friday, 12 July 2013, at 9:53 p.m.
  • RE: connection issues on 12.10 32bit
    Justin Killen -- Wednesday, 17 July 2013, at 1:41 p.m.
    • Re: connection issues on 12.10 32bit
      BillHatVerizon -- Wednesday, 17 July 2013, at 6:30 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.