Acctivate for CYMA users may receive errors signing into Acctivate or 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.
Try the suggested workarounds below if you receive this error after signing into Acctivate when both MSSQL and Actian Zen are installed on the same server.
Unable to open User: Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "SERVER".
Workarounds:
- Install latest service packs for Actian Zen.
- Reboot the server so that MSSQL and Actian Zen services are restarted.
- Repair PSQL / Actian Zen client.