Configure ODBC Data Source for print Document to Database


The Printer Driver “Print and Save to Database” feature requires an ODBC connection on the computer.


What is ODBC?


Open Database Connectivity (ODBC) is a standard application programming interface (API) for accessing database management systems. The designers of ODBC aimed to make it independent of database systems and operating systems. An application written using ODBC can be ported to other platforms, both on the client and server side, with few changes to the data access code.


In short, ODBC helps you to connect to any type of database easily.


To start configuring an ODBC connection, go to Control Panel > Administrative Tools > and open the ODBC Data Sources, or simply type “ODBC” to Windows Search.




The ODBC Data Source Administrator window opens. Go to System DSN tab, and Click on the Add button to add a new ODBC connection.




Select the Data Source driver. In most cases it is the SQL Server. Click on the Finish button to continue.




Enter a display name for the ODBC connection, and enter the remote database server IP address or domain name. Click on the Next button to continue.



Select the preferred authentication mode. In most cases, it’s SQL Server authentication. Enter the Login ID and Password for the remote database. The entered user must have read/write access to the remote database. Click on the Next button to continue.




Change the default database to the database where the documents must be uploaded to. Click on the Next button to continue.




On the following window, review the database settings and adjust the settings according to your requirements or database environment. Click on the Finish button to continue.




Review the summary page if all settings are correct. One can test the connection by clicking on the Test Data Source button. Click on the OK button to finish adding the ODBC connection.




The ODBC connection has been added to the computer:




Next time when starting the Print and Save Documents to Database feature of the Printer Driver, the new ODBC connection will be available in the ODBC Data Source list. For detailed information about how to configure the Print and Save Documents to Database utility, please refer to the following page.