Home Download Purchase Support Documentation

Print barcodes from SQL Server

Barcode Sphere Designer Documentation

Print barcodes from SQL Server


Following example use data from Xtreme 2008 database loaded to SQL Server 2012

graphic


Step 1. Define new ODBC-DSN. Open Control Panel and select Administrative Tools > ODBC Data Sources (32-bit).
graphic
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


Select System DSN and click Add button.

graphic

Select SQL Server driver available on your system.
graphic

Enter Name for data source (SQLSERVERXTREME in this example) and Server name or server IP address. Click Next.
graphic

Enter your authentication details (username/password). Click Next
graphic
Select "Change the default database to" and select database from list. In this example (xtreme). Click Next, and Finish.
graphic


Return to Barcode Sphere Designer. Start with New Design.

Step 2. Select page size and number of labels per page.
graphic

Click on OK button to confirm.





Step 3. Click on button "Select Data Source".
graphic



Step 4. Select Other database ODBC and click Next.
graphic

Step 5. Select previously created DSN name from ODBC DSN list (SQLSERVERXTREME in this example).


graphic
Enter User ID and Password. It is recommended to use user with limited set of privileges.

Click Test button and if connection is successful, click on OK button to select table/query.

Step 6. Select from a list of tables or database views (queries) - Product in this example. Click OK to confirm.
.graphic




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

graphic






Previous  Next


Copyright ProgramBL - All Rights Reserved