In case if you would like to try troubleshoot with a pure ODBC sample application connection (I mean outside of PHP environment), then here is the ODBC application sample code. 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 " So we had to roll the desktop back to Win8 and then it worked.
#INFORMIX ODBC DRIVERS#
Setup=/opt/IBM/Informix_Software_Bundle/lib/cli/iclis09b.so I couldn't run the Informix drivers on Win10, so I could host my UCCX Wallboard on a Win10 desktop. I have configures the odbc.ini and odbcinst.ini as such:ĭriver=/opt/IBM/Informix_Software_Bundle/lib/cli/iclis09b.so 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). (Figure 13)įigure 13 - Creating a table called 'People' in your Informix databaseīy selecting queries from your tables, you can create your SQL addressbooks in Ozeki Bulk Messenger.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.
#INFORMIX ODBC CODE#
Click 'Execute' to run the code on your Informix database. You can write your own codes or you can find example codes in Ozeki Bulk Messenger. You can test the database by using SQL code so click on 'SQL' to continue ( Figure 12). ( Figure 11)įigure 11 - You can see the database connection online, now you can click 'Open' Now click 'Open' to test the database connection. You will see a green tick if everything went fine.
#INFORMIX ODBC 64 BIT#
Answer In order to use a 32 bit ODBC driver on a 64 bit Windows machine, it has to be configured using a 32 bit ODBC Administrator which is not visible through normal Windows menu options. The driver is:įigure 10 - Filling out the connection details Step 6 - Testing out the database connection The IBM Informix 32 bit ODBC option will not be visible when using this utility. Step 4 - Open ODBC database connection in Ozeki Bulk MessengerĬlick 'Databases' from the 'Setup' menu ( Figure 8).Ĭlick on 'Create new database connection' and select 'ODBC' ( Figure 9).įigure 9 - Selecting ODBC Step 5 - Configure the ODBC connection in Ozeki Bulk Messengerįill out the connection details accurately and click 'Ok' ( Figure 10). We will now go back to Ozeki Bulk Messenger. If you see the 'Test connection was successful.' messagebox ( Figure 6) then it is sure that the IBM INFORMIX ODBC DRIVER can connect to your Informix database.įigure 6 - The 'Test connection was successful.' messagebox When you are ready click 'Apply & Test Connection' (Figure 5).įigure 5 - Filling out the connection details Now please fillout the connection details to your Informix database.
![informix odbc informix odbc](https://www.synametrics.com/images/setNet2.gif)
net OdbcConnection will just pass on the connection string to the specified ODBC driver. You need to add a data source name (Figure 4). See the respective ODBC drivers connection strings options. If you have connected successfully, then you can import contacts from your Informix database to the Ozeki Bulk Messenger software.įirst you need to search ODBC Data Sources from the Start menu ( Figure 1)įigure 1 - Create new connection Step 2 - Add an IBM INFORMIX ODBC DRIVERĬhoose 'IBM INFORMIX ODBC DRIVER (64-bit)' ( Figure 3).įigure 3 - Selecting 'IBM INFORMIX ODBC DRIVER (64-bit)' Step 3 - Connect the ODBC DRIVER to your Informix database Via ODBC you can connect to different types of database servers, because it is a general type of connection.
#INFORMIX ODBC HOW TO#
In this chapter you can learn how to connect to your Informix database through ODBC connection.
![informix odbc informix odbc](https://i.stack.imgur.com/gyi24.png)
How to setup an Informix database connection