Basic 2147217900 Error Encountered While Working in AGRIS

The following steps should be completed at the console of the database server itself:

1. Have the users exit the system.

2. Stop the Pervasive.SQL services (or just reboot the database server):

   1. Click Start > Run... > type CMD > click OK

   2. Type NET  STOP  "PERVASIVE.SQL  (RELATIONAL)" and hit Enter

   3. Type NET  STOP  "PERVASIVE.SQL  (TRANSACTIONAL)" and hit Enter

   4. Type EXIT and hit Enter

3. Copy all of the *.DDF files from the AGRIS\DDF folder into the Apps\AGRIS\Datasets\xxx folder

   1. Browse to the \\SERVER_NAME\Apps\AGRIS\DDF folder

      1. Note: SERVER_NAME is a just used as an example. Replace SERVER_NAME with the actual name of the database server.

      2. To browse to the above address, click Start > Run... > type \\SERVER_NAME\Apps\AGRIS\DDF > click OK

   2. Press Ctrl + A to highlight all of the objects in the DDF folder

   3. Press Ctrl + C to copy all of the highlighted objects to the clipboard

   4. Browse to the \\SERVER_NAME\Apps\AGRIS\Datasets\xxx folder

      1. Note: xxx refers to a specifically numbered dataset that corresponds to the dataset in V9 that is returning the error. For example, if users are encountering the error while working in the 002 dataset, then browse to the AGRIS\Datasets\002 folder.

      2. To browse to the address listed in the above example, click Start > Run... > type \\SERVER_NAME\Apps\AGRIS\Datasets\xxx > click OK

   5. Press Ctrl + P to paste all of the items from the clipboard into the folder

4. Reboot the database server

This error is typically caused when the DDF files from the AGRIS\DDF folder do not automatically update the AGRIS\Datasets\nnn\*.DDF files correctly.  It will be necessary to stop the Pervasive services copy the DDF files manually from the AGRIS\DDF folder and paste them into the numbered dataset folder that corresponds to the dataset encountering the problem.

The error reported contains the following information:
ERROR OCCURRED IN PROGRAM AgrisInterfaces
ERROR NUMBER: BASIC #-2147217900
ERROR MESSAGE: Microsoft OLE DB Provider for ODBC Drivers

Comments

• Failure to restart the server in step 4 above will result in the connection between the AGRIS COM+ applications and PSQL being broken, which WILL cause problems with AGRIS, iView, etc.Delete this comment

Attachment