Connections to a database can be established via existing ODBC DSN connection defined in
Control Panel - Administrative Tools - ODBC Data Sources (32-bit) or directly by loading one
of available database drivers.
IMPORTANT NOTE: if you are on a 64-bit machine, and If ODBC Data Sources (32-bit) is not
available in control panel, please activate 32-bit ODBC manager via START > RUN >
C:\Windows\SysWOW64\odbcad32.exe or activate cmd.exe and type
C:\Windows\SysWOW64\odbcad32.exe
Barcode Designer distinguish between connection methods using first keyword in
connect string. ODBC DSN connections start with first keyword DSN and driver loading
method have different first keyword such as DRIVER or Provider.
DSN Example:
DSN=Xtreme;Uid=#USERNAME#;Pwd=#PASSWORD#;
Driver Loading Method Examples:
DRIVER={MySQL ODBC 5.51.30
Driver};Database=test;Server=192.168.1.101;UID=#USERNAME#;PWD=#PASSWORD#;
or
Provider=msdaora;Data Source=MyOracleDB;User
Id=#USERNAME#;Password=#PASSWORD#;
Note variables #USERNAME# and #PASSWORD# in connect strings are placeholders which
will be replaced by actual username/password entered in logon dialog.
To establish connection to database by manually entering connection string, click on "Select
Data Source" button.
Select Database Connection Sting and click Next.
Select from a list of Data Providers and modify connect string to match database
requirements.
If database require entering username/password, Barcode Designer will popup logon
dialog and replace #USERNAME# and #PASSWORD# from connect string with data entered
in connect dialog.
Connection strings can vary greatly depending on installed components, please consult your
database administrator or online resources such as http://www.connectionstrings.com/ for
connection string sample for particular database.
Click Test button and if connection is successful, click on OK button to select
table/query.
Click OK to confirm table selection.
Add design components.

While component is selected, click on 'Database Column' property in Property
Inspector. Select from a list of available columns from previously selected table or
view.
Copyright IsimSoftware - All Rights Reserved