Data Sources

Owned by Former user (Deleted)
Last updated: Oct 14, 2016 by Mike Hartnett
2 min read

ProWrite can store connection information to multiple databases. To add a new connection or to switch from one database to another select Tools → Data Source(s). Before change the data path in ProWrite, first close all open entities. ProWrite will need to restart to switch between datastores and any unsaved changes will be lost.

In the ProWrite Database Connection Manager connections to the below database types can be managed. This dialog is unnecessary in ProWrite Cloud

  • Offline Local SQL
  • Legacy (ProWriteOL.DB)
  • MS SQL Server


The ProWrite Legacy DB UNC Path can be used for a mapped drive to a Legacy (ProWriteOL.DB) database.


To use a given data source select it in the grid and select Use Selected and Save & Close. The program will close and reopen connecting to that data source. 

MS SQL Server

For MS SQL Databases a UDL/Data Link screen will appear as below.

Please contact your IT department for specifics but typically you would select Microsoft OLE DB Provider for SQL Server then Next and then type the Server/Instance Name in 1 (it may be available in the dropdown if the SQL Server Browser Service is running) then the credential type/credentials in 2 (this is defined by the SQL Server Instance and would typically be Windows only or Mixed-mode) and finally the database name in 3. You can then verify connectivity via Test Connection and save this connection via OK.