Resolving the " Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server ..." error

Acctivate for CYMA users may receive errors loading customer invoices after upgrading or installing SQL Server

Acctivate for CYMA users may receive an error similar to the following:

Link of CYMAdemo.AcctivateCYMAdemo..Ap_In failed due to error ExecuteNonQuery failed for Database 'ACCTivate_demo'. --> An exception occurred while executing a Transact-SQL statement or batch. --> Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "CYMAdemo".OLE DB provider "MSDASQL" for linked server "CYMAdemo" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".

If Microsoft SQL Server is installed on a separate machine than Acctivate and CYMA and Pervasive, this may lead to an issue in which SQL Server and Pervasive are unable to link together.  This would cause Acctivate users to receive the error, above, due to not being able to load data from CYMA.

The solution is rather simple.  Wherever Microsoft SQL Server is installed you will need to also install the Pervasive Client.  This loads the Pervasive ODBC Interface driver, which is used between SQL Server and Pervasive to create a linkage. 

You can download the Pervasive Client Driver from Actian or you can also install the Pervasive Client from the CYMA Installation CD.