Table of Contents

SetODBC
- Phase
  - Syntax
  - Example
  - Example

SetODBC

Set the ODBC connection string and instruct the Import Engine to use ODBC mode.

Phase

This instruction is used by the TapeTrack Import Engine.

Syntax

SetODBC(odbc);

odbc The ODBC connection string.

Example

SetODBC: Select the Microsoft Access Driver and pass the Access file to use.

SetODBC("Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\Data\Sync\Tapes.mdb");
SetSQL("SELECT Barcode,Location FROM [Inventory]");

Example

SetODBC: Select the Microsoft Excel Driver and pass the Excel file to use.

SetODBC("Driver={Microsoft Excel Driver (*.xls)};Dbq=C:\Data\Sync\Tapes.xls");
SetSQL("SELECT Barcode,Location FROM [Inventory$]");