AMT Datasouth Fastmark M1 Uživatelská příručka stáhnout pdf (Strana 353)

Working with ODBC

Note: If you are using the LPS, you may not need ODBC.Please refer to the

Loftware Print Server User Guide

for

more information.

ODBC (Open Database Connectivity) is Microsoft’s strategic interface for accessing data in an

environment of relational and non-relational database management systems (DBMSs).ODBC allows

applications to access multiple data sources without having to understand the underlying format of the

data being read. It is through this mechanism that the Loftware system is able to access your data.

The standard Loftware setup program installs Microsoft Data Access Components (MDAC) which

includes the following ODBC drivers: Microsoft Access, dBASE, Microsoft Excel, Microsoft FoxPro,

Paradox, Text (CSV and Fixed Length), SQL Server, and Oracle.16-bit drivers are not included.If your

data is in a different format, such as DB2, Sybase, or Btrieve you must obtain a 32-bit ODBC driver that

is compliant with your database. You can often find these drivers by contacting your provider or by

searching on the Internet.

Note: During installation of a Loftware upgrade, the schema.ini file located in the <Program Files

Folder>\Loftware Labeling\dbases\ folder is overwritten. The schema.ini file is used by ODBC for connectivity

to text files.Several text files can share one schema.ini file, but there can only be one such ini file per

folder.Because Loftware supplies sample text files for ODBC, the upgrade installation must update, and

therefore overwrite, the schema.ini file located in the <Program Files Folder>\Loftware Labeling\dbases\

folder.It is therefore recommended that if you are using text files with ODBC, use a folder other than the

<Program Files Folder>\Loftware Labeling\dbases\ folder.

ODBC manages databases through the use of registered data sources.A data source consists of a specific

set of data (for example, a database), the information required to access that data, and the location of the

data source.

Examples of Data Sources

l A directory containing a set of dBase files you want to access.

l An SQL Server database, the server on which it resides and the network used to access that

server.

l A Microsoft Access database

l An Oracle database through a gateway to a Vax or AS/400

Connecting to a data source means establishing communications with a DBMS in order to access that

data source’s data.When you connect to a data source from an application through an ODBC driver, the

driver makes the connection for you, either locally or across a network.

Loftware LabelManager Version 10.1.1 User's Guide

353

1 2 ... 348 349 350 351 352 353 354 355 356 357 358 ... 531 532

Žádné komentáře

AMT Datasouth Fastmark M1 Uživatelská příručka Strana 353