A data source name (DSN) is a data structure that contains the information about a specific database that an Open Database Connectivity ( ODBC ) driver needs in order to connect to it. 


Features that will utilize/require this setting are:

  1. Speed up System5 searching (Inventory, Customer, Invoices, etc)
  2. Enable “Multiword Searching”
  3. System5 Application Server (Bound book, MobilePOS, Form Customization)


Enable DSN in System5:

  1. Go to Setup Wizard
  2. Network Settings
  3. Pervasive.SQL DSN Less Connection
  4. Enter the DSN Name and name of the server
  5. Enable Client DSN Less Connection
  6. Test SQL

On the right side box,

  1. Turn on DSN to terminals
  2. Click the “Test SQL” button to test

see the image below…..