Home Download Purchase Support Documentation

Print barcodes from any ODBC compliant database

Barcode Sphere Designer Documentation

Print barcodes from any ODBC compliant database
Barcode Sphere Designer support connections to any ODBC compliant database.

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 Sphere 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.

graphic


Select Database Connection Sting and click Next.
graphic


Select from a list of Data Providers and modify connect string to match database requirements.
graphic

If database require entering username/password, Barcode Sphere 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.
graphic
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.
Previous  Next


Copyright ProgramBL - All Rights Reserved