ODBC Database Set Up Guidelines

Before you can use MGI with an ODBC database, the server administrator must properly set up and test the ODBC data source in the control panels of the operating system. Next, the ODBC data source has been set up, the server administrator must configure the ODBC username and password in the database's proprietary interface or application.

Some database systems require user permissions to be set on a per-database basis. MGI cannot use a database unless MGI has been granted access to the database.

Some database drivers do not automatically enable important functions such as multi-threading, updates and deletes, and other important options. In order for MGI to function to the database's capacity, you must enable these functions when you configure the data source.

Please contact the ODBC database manufacturer for any questions regarding the installation of the database itself or configuration of the ODBC database.

MGI is able to access ODBC databases with ODBC drivers. Some drivers are included in the MGI 2.x installer while others are included as part the the ODBC database's package. The following drivers are included with the MGI Macintosh and NT/2000 installers.

Macintosh Drivers

  • dBASE
  • FoxPro
  • Oracle 7
  • Text (flat file driver)

MGI works with FileMaker, but the database driver is included with the FileMaker program and is not installed by MGI.

Win32 Drivers

  • Btrieve
  • dBASE
  • Excel Workbook
  • Informix 7.x, 9.x
  • Oracle 7, 8
  • Paradox
  • SQL Server 7, 2000
  • SQLBase
  • Sybase Adaptive Server
  • Text (flat file driver)

[Return to the Using ODBC Databases Menu]

[Understanding MGI Menu] [Using MGI Menu] [Referencing MGI Menu]

[MGI Guides Main Menu] [User Guide Main Menu]