ADO/OLE DB Connection


Active Data Objects (ADO), also referred to as OLE DB, allows connections to many different types of databases including Oracle, MySQL, DB2, FoxPro, and others. A connection string is used to provide database connection parameters including the database name, user ID, password, and other settings. Refer to the connection string references for information on connection strings for different database types. ADO is the successor to Open Database Connectivity (ODBC).


Use this dialog to specify an ODBC connection string and SQL query statement for a source database. You can enter a connection string manually, or use the Connection String Builder to easily build connection strings for some common databases.


You must also provide an SQL query for the database. The query can include join statements to link multiple tables together, but make sure that the resulting record set includes all fields required by ChemStat.