There is a parameter called TCPFINWAIT2FLUSHINTERVAL that sets the amount of time that a connection will stay in this state. This kill is not a graceful process so it will leave TCP/IP connections on the port with a status of FINWAIT2. String connStr ="CursorBehavior=0 Driver=IBM INFORMIX ODBC DRIVER DB_LOCALE=en_US.819 Host= Server= Service=31012 UID=informix Password=xxxxxxx Protocol=olsoctcp DB=xxxx Pooling=false" Going into single user mode ( onmode -j ) kills all non-DBSA/informix user connections to the server. I am having a problem building a connection string that works using the 4.10 client. I was trying to find out if I could skip the DSN setup in the ODBC manager and place it in the a config file instead. I've installed the informix client sdk for odbc drivers to create odbc 32 bit. I'm using Microsoft Excel 2010 + Windows 7 Professional 64 bit.
#Informix odbc driver cannot sum how to
I can build a system dsn and call it directly and it works great. How to install an Informix ODBC driver on Windows 7 (for MS Office 2010). net native drivers for informix because of the drda protocol requirement. I have been using the following guide and different parameters to attempt to build a connection Note that cBases cannot be used when connecting to a version 7.0 server. For ODBC they are simply represented as a single table named data. cBases (DiveLine 7.1 only) Spectre cBases are basically tables.
Is there an obvious to semi obvious problem with the connection string that I am attempting to use to connect to informix. This section explains how each source type is represented as a database in the driver.