ODBC-Datasources (both 64-Bit and 32-Bit) have been created and tested (they work fine).
#SETUP INFORMIX ODBC DRIVER#
The driver ifxoledbc has been registered. Using setnet32 the registry entries for host:port have been set. I am an Apple Consultant (But Microsoft Certified too.
#SETUP INFORMIX ODBC MAC OS#
We are running Mac OS Mojave 10.14.2, are using Informix Database Engine v 11 and are accessing data via Excel - running on Office 365 version of Excel (64 bit) All works fine from Windows based Excel, need to get a few Macs connected. You might type the following to describe the sample OLAP Metadata Catalog database: Sample OLAP Metadata Catalog Informix Client SDK and Microsoft Data Access Components have been installed on the Client PC. Hello, we are having basic issues getting the Mac version 7 ODBC driver to connect to our single database. You might type the following to describe the sample application database: Sample relational data source Optional: If you want to record a description, in the Description text box, type a description that indicates how you use this data source name.įor example, you might type the following to describe the My Business database: Customers, products, markets
#SETUP INFORMIX ODBC INSTALL#
In the sample application, TBC is the data source name used to connect to the Data Source database called TBC TBC_MD is the data source name used to connect to the sample OLAP Metadata Catalog database called TBC_MD. Run the setup program, allowing the Informix installation wizard to guide you through the process of installing the ODBC drivers which are in the client SDK. In order to connect to an Informix database you need to install an Informix Client, such as IBM Informix Connect. 1) Create VS 2010 C++ Console Application Project File -> New Project Visual C++ Win32 Console. (If you want to use by using driver manager then change the include and library accordingly from the instruction). Here is the instruction to use Informix ODBC driver directly. In the Data Source Name text box, type the name that you want to use for this data source connection. Using ODBC driver directly Using ODBC driver through a driver manager. The Wire Protocol Driver Setup dialog box for your RDBMS is displayed. In the driver list box of the Create New Data Source dialog box, select the appropriate Wire Protocol driver for your RDBMS, and click Finish. In the ODBC Data Source Administrator, click Add to open the Create New Data Source dialog box. There are two basic ways to connect to the ODBC data source: Configure DSN using the ODBC Administrator control panel, then specify the DSN name in the DataSource parameter In the FireDAC Connection Editor (see Defining Connection (FireDAC) for details), specify the ODBCDriver parameter value, and then click the Wizard button.