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 for Me (Login required).

Search for additional results

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