#Microsoft set up informix odbc sources drivers

Multiple Tier drivers are intended for typical client/server architectures, such as Oracle, Informix or Sybase. Other calls are modified by the driver to fit the syntax required by DBMS. Set up an OLE-DB Data Source in BIDS with your Destination Server as Target, giving it the following query: SELECT a linked Server on the Destination Server in the Management Studio, giving it the name of the ODBC-Source. It is also possible to define DBMS specific calls. Set up the Informix Source as System DSN Source. The driver processes ODBC calls and forwards the SQL commands to the server. Multiple Tier drivers require a server that processes the SQL statements and is the interface to the data source. As a minimum they have to provide the minimum commands defined by ODBC. Note that these drivers usually limit the SQL statements offered. The driver converts them into elementary file operations. In this case, the driver processes the ODBC calls and the SQL statements. Single Tier drivers are intended for data sources that do not have an SQL interface, such as Microsoft Excel, dBase or text files. They are divided in Single Tier and Multiple Tier drivers. The drivers form the ODBC interface for the data source and are provided by Dynamic Link Libraries (DLLs). It will load and manage the driver needed for specific tasks. Microsoft Windows provides the O DBC Driver Manager by default. This interface allows you to establish a connection to any data source, for which an ODBC driver is available, to define SQL run time statements and to send those to the data source. Plant Simulation implements the ODBC interface employing so called ODBC calls. Plant Simulation and the data source communicate via the ODBC Driver Manager and the ODBC Database Driver.

The advantage of the ODBC ( Open Database Connectivity) interface over product-specific interfaces is that it allows you to access different data sources, such as Microsoft Excel, dBase, and text files as well as Database Management Systems ( DBMS) such as Oracle or Informix, as long as the corresponding drivers are installed on your computer. To provide several database connections, duplicate the object ODBC in the Class Library as often as you need to. The ODBC interface connects to any existing data source.