2.10 Configure Pervasive Database

NSN scripts can access pervasive SQL.2000 database through ODBC. Proceed with the following steps to configure Pervasive.SQL 2000 database.

  1. Load the Pervasive database server by typing mgrstart at the server console.

  2. Install the Pervasive client on a Windows machine by running SYS:\PVSW\CLIENTS\WIN\SETUP.EXE available on NetWare server.

  3. From the client start Pervasive control center by clicking Start > Programs > Pervasive > Pervasive Control Center.

  4. Goto center > click Connect to Server . Add Server dialogue box is displayed. Add Server dilogue box can also be displayed by clicking the Connect icon or right-clicking Pervasive Servers > Connect To Server.

  5. Enter the IP address of the server that is to be connected > click OK. The server will be listed under Pervasive servers.

  6. Click the Specified server > login as the administrator of the server.

  7. Right-click database > add database.

  8. Enter the database name (DSN name of the new database).

  9. Enter the path to datafiles. The path should be entered as <servername>\<volumename>\<destination directory> > click OK.

  10. To access the tables available in the new DSN, double-click the new DSN > login as administrator.