When Using the Pervasive SQL Driver Integration Library - "Connection Test Failed" Error is Displayed.

Products

• Workflow Solution
• ServiceDesk

Issue/Introduction

When attempting to use the Pervasive SQL Provider to generate any Pervasive database connection integration component, when attempting to test the connection, you will receive an error.  If you have existing components already using the library, you will also see the following error."Connection Test Failed". 

1. If you are attempting to create and test a SQL integration connection using the Pervasive Provider, you will see  - "Connection Test Failed"
2. If you have an existing Workflow that has a database connection component pointing to a Pervasive SQL provider, you will see the following when attempting to run the Workflow, or edit the integration component. -  "Could not load file or assembly 'Pervasive.Data.SQLClient, Version x.xx.x.x, Culture=neutral, PublicKeyToken=c84cd5c63851e072' or one of its dependencies. The system cannot find the file specified."

Environment

ITMS 8.x

Workflow 8.1 and later

Cause

Symantec no longer distributes the Pervasive SQL library with Workflow Solution. 

Resolution

You can still use the Pervasive SQL library to make connections to your pSQL databases, and also generate integration components for that connectivity:

1. You must copy the Pervasive.Data.SQLClient.dll from your pSQL server to the Workflow server.  
2. The dll file can be found in ...\Program Files (x86)\Actian\PSQL\bin\ADONET4.2.
3. Copy the file to the Workflow server, to the …\Program Files\Symantec\Workflow\Shared\lib folder, and then you can use the generator to create the integration components you need.  Your existing projects will also function correctly.