TapeTrack Documentation

Because there is more to tape management than you ever realized

User Tools

Site Tools

Trace:
engine:import:setodbc

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
engine:import:setodbc [2019/02/18 02:05] – [Example] Scott Cunliffeengine:import:setodbc [2025/01/21 22:07] (current) – external edit 127.0.0.1
Line 2: Line 2:
 Set the ODBC connection string and instruct the Import Engine to use ODBC mode. Set the ODBC connection string and instruct the Import Engine to use ODBC mode.
  
-==== Phase ====+===== Phase =====
 This instruction is used by the TapeTrack Import Engine. This instruction is used by the TapeTrack Import Engine.
  
Line 8: Line 8:
 **SetODBC**//(odbc);// **SetODBC**//(odbc);//
  
-string //odbc;//\\ +  * ''odbc'' The ODBC connection string.
-odbc The ODBC connection string.+
  
 ==== Example ==== ==== Example ====
 SetODBC: Select the Microsoft Access Driver and pass the Access file to use. SetODBC: Select the Microsoft Access Driver and pass the Access file to use.
  
-<sxh>+<code>
 SetODBC("Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\Data\Sync\Tapes.mdb"); SetODBC("Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\Data\Sync\Tapes.mdb");
 SetSQL("SELECT Barcode,Location FROM [Inventory]"); SetSQL("SELECT Barcode,Location FROM [Inventory]");
-</sxh>+</code> 
 ==== Example ==== ==== Example ====
 SetODBC: Select the Microsoft Excel Driver and pass the Excel file to use. SetODBC: Select the Microsoft Excel Driver and pass the Excel file to use.
  
-<sxh>+<code>
 SetODBC("Driver={Microsoft Excel Driver (*.xls)};Dbq=C:\Data\Sync\Tapes.xls"); SetODBC("Driver={Microsoft Excel Driver (*.xls)};Dbq=C:\Data\Sync\Tapes.xls");
 SetSQL("SELECT Barcode,Location FROM [Inventory$]"); SetSQL("SELECT Barcode,Location FROM [Inventory$]");
-</sxh>+</code>
engine/import/setodbc.1550455557.txt.gz · Last modified: 2025/01/21 22:07 (external edit)