ODBC Configuration

When you install CIMPLICITY if you:

  • Install the (MSDE) database server option, a Microsoft SQL-compatible database server, the ODBC driver will be SQL Server data sources.
  • Do not install the server, CIMPLICITY  redistributes ODBC using Microsoft data access components.

You do not need to purchase or configure additional software to use these drivers.

Tip: Install the database server because, as a SQL server, it provides better scaling when you want to go to a more robust SQL server to support Enterprise type solutions.

For improved performance and network extensibility, you may wish to log to a third-party database product such as Microsoft SQL Server or Oracle.