Error connecting to onprem SAP instance with ODBC drivers

[refh0111]

I have a problem connecting to an onpremises SAP instance using Microsoft Fabric even though I had downloaded the right ODBC driver that was suggested to be downloaded. The 64bit one, I even tried connecting to power BI since it is almost the same way of connecting and still experienced the issue of connecting. 

This is the error that I keep getting even though the right driver is installed on the machine housing the SAP instance. 

I require urgent assistance on this. Thank you

[v-shex-msft]

Hi @refh0111,

Any update on this? Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

Regards,

Xiaoxin Sheng

[v-shex-msft]

HI @refh0111,

According to the error message, the issue seems related to the data source accessibility. Did that datasource required any proxy or Vnet settings to connections?
In addition, it also mentions about the 'HDBODBC' driver. Have you check the configuration and ensure it can be accessed?

Regards,

Xiaoxin Sheng

[FabianSchut]

What setup do you use for connecting to this the on-premise server? Do you have a VM installed with the on-premise gateway and the odbc driver installed on the same VM, or do you have the gateway and odbc driver directly installed on the SAP server?

Do you also have some more information about the connection you have created in Fabric? Can you share some screenshots of the configuration?

[refh0111]

@FabianSchut