Skip to content
logo Knowledgebase

Database could not be found or automatically created when editing customers, suppliers or inventory

Created on  | Last modified on 

Summary

In this article we provide steps on how to resolve error "Database could not be found or automatically created" when editing customers, suppliers or inventory on Sage 50cloud Pastel Accounting.

Description

For enhanced search and running of Sage Intelligence reports to work a database connection for each company in Pervasive Control Center (PCC) is required. 

The database connection should be automatically created the first time you use enhanced search or run Sage Intelligence reports. If there's no connection or the connection cannot be automatically created you will get the error as below. 



Resolution

To resolve the error, you will need to manually create the database connection for the company in Pervasive Control Center (PCC) as per steps below.

Creating Database using Pervasive Control Center           

  1. Open the Run command by pressing the Windows logo key Picture of the Windows logo key+R on your keyboard
  2. Type pcc as shown below and click OK
  3. In the Pervasive Control Center there are two panes, on the left-hand pane expand Engines you should see the server computer name. Expand the computer name to see Databases as shown below:
     

     NOTE: If using Pervasive Workgroup it will be the workstation name and on a Client/Server Installation it will be the Server name. 

    If on a Client/Server installation you need to Expand on the server’s computer name. If the server’s computer name is not showing, right click on Engines, select New  and select Server. Enter the server’s computer name and click OK.

  4. Right click on Databases, select New and then DatabaseGraphical user interface, applicationDescription automatically generated
  5. On the New database screen enter the company name on the Database Name field. The database name should start with PAS19 and then the company folder name e.g. if your company folder is DEMO, you should enter the database name as PAS19DEMO
  6. On the Location field click on the eclipse button as shown below and navigate to the company folder. Select the company folder and click OK.
  7. Once you have selected the company folder make sure that the above is as per the screenshot and you have deselected the option Create Engine DNS
    .
  8. Click Finish and close the Pervasive Control Centre


If the error persists, and you cannot create the database connection manually, you need to disable the enhanced search function for the affected user/s follow the steps below:

  1.  Go to Setup | Users / Passwords | Users
  2. On the screen that opens, select the username for the affected user and click on User Preferences
  3. On the screen that opens, deselect Use Enhanced Search under Customers, Suppliers and Inventory and click OK.