I then set-up the environment variables with the following commands: export INFORMIXDIR=/opt/IBM/Informix_Software_BundleĮxport LD_LIBRARY_PATH=$/lib/cliįYI: Since you have created a DSN (with the INI file), you could just specify the DSN name in the connection string used by the PHP application, for example: "DSN=informix_db uid=xxx pwd=xxxx " Setup=/opt/IBM/Informix_Software_Bundle/lib/cli/iclis09b.so The rich ecosystem of Python modules lets you get to work quicker and integrate your systems more effectively. Leverage the pyodbc module for ODBC in Python.
I have configures the odbc.ini and odbcinst.ini as such:ĭriver=/opt/IBM/Informix_Software_Bundle/lib/cli/iclis09b.so The CData ODBC Driver for IBM Informix enables you to create Python applications on Linux/UNIX machines with connectivity to IBM Informix data. I am using php7.0 and I have installed the unixODBC-2.3.7 as well as installed the informix sdk package (iif.12.10.FC12DE.linux-x86_64). The IfxOdbcSample1 directory has ODBC application build infrastructure including a Visual Studio 2015 project. When you are ready click Apply & Test Connection (Figure 5 ). Now please fillout the connection details to your Informix database. You need to add a data source name (Figure 4).
In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.I am woking on a virtual machine operating CentOS 7, and I am trying to connect to an Informix database using ODBC (unixODBC) through some php. The source code for Informix ODCB Examples are at src directory. Step 3 - Connect the ODBC DRIVER to your Informix database. The entire risk arising out of the use or performance of the sample code is borne by the user. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The sample code is provided on an "AS IS" basis.
Progress Software Corporation makes no explicit or implied claims to the validity of this information.Īny sample code provided on this site is not supported under any Progress support program or service. When you are ready click 'Apply & Test Connection' (Figure 5 ). I ran a quick test on my Ubuntu box and it works fine. In the meantime you should be able to connect using the provider, just make sure you have set UNICODEUCS-2 in your ODBC.INI. However, the information provided is for your information only. Step 3 - Connect the ODBC DRIVER to your Informix database. NET Core provider would be available for Windows and Linux in the next version of Informix CSDK. Progress Software Corporation makes all reasonable efforts to verify this information. The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”).