SAP Knowledge Base Article - Preview

2575284 - Communication between SQL Server Analysis Services and ADS not working

Symptom

Processing a database in SQL Server Management Studio, that was created by deploying an Analysis Services Multidimentional and Data Mining project created by Visual Studio, returns the error below:

Error 5018: The handle given was not recognized by Advantage. Verify specified handle is open/active. The given handle is not recognized as a valid Advantage Client Engine handle.

0.jpg


Read more...

Environment

SAP ADS 12 SP 02 64-bit
SAP ADS OLEDB provider 12.0.0.2
SAP ADS ADO.NET provider 12.0.0.2
Microsoft Visual Studio 2015
Microsoft SQL Server 2016 64-bit

Product

SAP Advantage Database Server 12.0

Keywords

Sybase, provider not registered, oledb , KBA , BC-SYB-ADS , ADS (Advantage Database Server) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.