(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.
REMOVE INFORMIX ODBC DRIVER
CLI is composed of API libraries, a version of the driver manager and a version of the ODBC driver. Informix-CLI is a call level interface, or connectivity tool that enables applications to dynamically access Informix database servers. Click 'Execute' to run the code on your Informix database. Informix-CLI is the Informix implementation of the Microsoft ODBC standard. 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. The driver is:įigure 10 - Filling out the connection details Step 6 - Testing out the database connection
![remove informix odbc remove informix odbc](https://razorsql.com/images/docs/informix_drop_view.png)
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. Terminates a logical unit of work, undoes all changes made to the database since the beginning of the logical unit of work, and starts a new. 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 DISCONNECT automatically executes a COMMIT to guarantee that all changes made to the database since the beginning of the current unit of work are committed. 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. You need to add a data source name (Figure 4). 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.
![remove informix odbc remove informix odbc](https://image.slidesharecdn.com/informixuserguide-120313035346-phpapp02/95/informix-user-guide-39-728.jpg)
![remove informix odbc remove informix odbc](https://image.slidesharecdn.com/informixphysicaldatabasedesign-110830121705-phpapp01/95/informix-physical-database-design-for-data-warehousing-5-728.jpg)
REMOVE INFORMIX ODBC HOW TO
In this chapter you can learn how to connect to your Informix database through ODBC connection. How to setup an Informix database connection