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.

Author


Was this article helpful?

Related Articles