## Print barcodes from Oracle

#### Barcode Designer Documentation

Print barcodes from Oracle (Example - Print Name/Identification Cards)
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 or activate cmd.exe and type C:\Windows\SysWOW64\odbcad32.exe
Select System DSN and click Add button.
Select Oracle driver available on your system.
Enter Data Source Name (DSN) and select TNS Service Name.
Click Test Connection and confirm on OK button if connection successful.
Step 2. Start Barcode Designer and select new design. 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 (ORATEST 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 5. Select from a list of tables or database views (queries).
Click OK to confirm.
Step 6. Add design components.
While component is selected, click on 'Database Column' property in Property Inspector. Select from a list of available columns from the Oracle table. Repeat step 6 until design is complete.
Step 7. Click on a Print Preview button to see data from Oracle printed on the label.
Click on Page up/down to navigate through pages.
`Previous Next`
Copyright IsimSoftware - All Rights Reserved