Print barcodes from SQL Server
Following example use data from Xtreme 2008 database loaded to SQL Server 2012
Step 1. Define new ODBC-DSN. Open Control Panel and select Administrative Tools
> ODBC Data Sources (32-bit).
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 >
Select System DSN and click Add button.
Select SQL Server driver available on your system.
Enter Name for data source (SQLSERVERXTREME in this example) and Server
name or server IP address. Click Next.
Enter your authentication details (username/password). Click Next
Select "Change the default database to" and select database from list. In this
example (xtreme). Click Next, and Finish.
Return to Barcode Sphere Designer. Start with New Design.
Step 2. Select page size and number of labels per page.
Click on OK button to confirm.
Step 3. Click on button "Select Data Source".
Step 4. Select Other database ODBC and click Next.
Step 5. Select previously created DSN name from ODBC DSN list
(SQLSERVERXTREME in this example).
Enter User ID and Password. It is recommended to use user with limited set of
Click Test button and if connection is successful, click on OK button to select
Step 6. Select from a list of tables or database views (queries) - Product in this
example. Click OK to confirm.
Step 7. 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. Repeat step 7 until design is complete.
Step 8. Click on a Print Preview button to see data from SQL Server table or view
printed on the labels.
Copyright ProgramBL - All Rights Reserved