Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 92%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Same issue , document was folowd
Azure Data Factory - Connection Error for Sybase SQL Anywhere 16.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 83%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Ather Hussain
31
Reputation points
Hi,
I am trying to create a Sybase Linked Service in Azure Data Factory V2. But the connection is not Successful. I have installed self hosted Integration Runtime in the Sybase DB server and also installed data provider for Sybase iAnywhere.Data.SQLAnywhere 16. Sybase is SQL Anywhere 16 version installed in Azure VM. Tested Integration Runtime with SQL connections in ADF and it's working fine. Getting the below error when trying to create the linked service for this.Looks like data provider having some issue.
Error Message:
Type=Microsoft.Data.Mashup.MashupValueException,Message=Sybase SQL Anywhere: We were unable to find a database provider with invariant name 'Sap.Data.SQLAnywhere'.
This error could've been the result of provider-specific client software being required, but missing on this computer. To download client software for this provider, visit the following site and choose the 64-bit (x64) version of, at minimum, 'Sybase SQL Anywhere Client Software': https://go.microsoft.com/fwlink/?LinkId=324846,Source=Microsoft.Data.Mashup.ProviderCommon,'
Activity ID: 2086bfdb-9a6a-4c41-8637-a7772d7434f2.
Any pointer on this will be helpful.
Thanks in Advance.
Ather
Azure Data Factory
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 9%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HarithaMaddi-MSFT 10,146 Reputation points2020-11-02T07:47:49.833+00:00 Hi @Ather Hussain ,
Welcome to Microsoft Q&A Platform. Thanks for posting the issue.
Please suggest if details as mentioned in document are noted while using the connector. If issue persists after meeting the criteria listed in the document, since it involves Self hosted integration runtime (SHIR), please share report id by following below steps that enables our team to dig into details. Also please share data factory name, region.
Steps to share report id:
In the integration runtime configuration manager, please click on diagnostics icon, reproduce the error and then click on ‘Send logs’. You will be able to see report id, please share that with us to enable viewing logs.
Looking forward for more details from you to investigate!
-
HarithaMaddi-MSFT 10,146 Reputation points
2020-11-03T07:06:16.07+00:00 Hi @Ather Hussain ,
We have not received a response from you. Are you still facing the issue? If you found a solution, would you please share it here with the community? Otherwise, let us know more details as requested and we will continue to engage with you on the issue.
-
HarithaMaddi-MSFT 10,146 Reputation points
2020-11-04T17:13:12.667+00:00 Hi @Ather Hussain ,
We still have not heard back from you. Following up to check If you found a solution, would you please share it here with the community? Otherwise, let us know more details as requested and we will continue to engage with you on the issue.
Sign in to comment
2 answers
Sort by: Most helpful
-
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 8%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELJ%3C/text%3E%3C/svg%3E)
LEONARDO J VILLARROEL CUBILLOS 1 Reputation point2022-08-10T19:03:30.817+00:00 Same issue over here!!!. please help?.