1. Home
  2. Labeling Software
  3. CODESOFT
  4. CODESOFT Instructions
  5. CODESOFT Instructions - Data Sources (Multiple Types)
  6. ODBC vs OLEDB Data Source Connections with TEKLYNX Labeling Software – TEKLYNX Reference Article

ODBC vs OLEDB Data Source Connections with TEKLYNX Labeling Software – TEKLYNX Reference Article

Summary

This Reference Article defines and explains the use of ODBC and OLEDB data source connections with TEKLYNX labeling products (CODESOFT, LABELVIEW, LABEL MATRIX).

Information

To connect to a database, CODESOFT needs to use a driver and send, to that driver, critical information. The driver needs this information to find and open the database (e.g. database server, name, login, password, special query, etc.). Two options include:

  • Windows ODBC connections
  • CODESOFT OLEDB connections

Windows ODBC Connections

Users store these connection settings within Windows and make them available to any software running on that device. Use the ODBC Data Source Administrator within Windows as the  interface to add, update, or delete the connection settings. The same UI can be accessed in Windows or though CODESOFT.

CODESOFT OLE DB connections

Users create, store, and change these settings from within CODESOFT. The settings are stored in a file. CODESOFT saves these files, by default, in the DataLink folder in ProgramData/Teklynx/CODESOFT.

Examples

Although we recommend editing these setting via the CODESOFT UI, a text editor can view and even edit these setting directly.

Updated on December 5, 2018

Was this article helpful?