## Print barcodes from SQL Server

#### Barcode Designer Documentation

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 > C:\Windows\SysWOW64\odbcad32.exe
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 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 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.
.
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.
`Previous Next`
Copyright IsimSoftware - All Rights Reserved