Wednesday, 7 July 2010

Create Databases and Datasource Names (DSNs) in Pervasive.SQL

To create company and system databases in Pervasive.SQL:

  1. Click Start > All Programs > Pervasive > Pervasive.SQL Control Center.
  2. In the Common Tasks section in the right panel, click New Database. The New Database window opens.
  3. In the Server field, click the down arrow, select a server from the list, and then click Next.
  4. In the Database Name field, type the name of the folder you created for the database. Note: The folder name and the database name must be identical.
  5. In the Location field, type the path to the folder you created for the database.
  6. In the DBName Options section, select Bound and Create Dictionary Files. Do not select the option, Relational Integrity Enforced, as Sage Accpac checks integrity.
  7. Select the Create DSN option, and leave Normal as the Open Mode. Note: The DSNs are used in Database Setup when you set up your system and company databases.
  8. Click Finish.
  9. Create other databases (for example, if you created a system database, now create a company database).
  10. Close the Pervasive.SQL Control Center.