Home Download Purchase Support Documentation

Print barcodes from Oracle

Barcode Sphere 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).
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 or activate cmd.exe and type C:\Windows\SysWOW64\odbcad32.exe


Select System DSN and click Add button.

graphic







Select Oracle driver available on your system.
graphic





Enter Data Source Name (DSN) and select TNS Service Name.
graphic
Click Test Connection and confirm on OK button if connection successful.








Step 2. Start Barcode Sphere Designer and select new design. 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 (ORATEST 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 5. Select from a list of tables or database views (queries).
graphic
Click OK to confirm.



Step 6. Add design components.
graphic
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.
graphic
Click on Page up/down to navigate through pages.

graphic
Previous  Next


Copyright ProgramBL - All Rights Reserved