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

[refh0111]

Hi, these suggestions still have not helped at all. the error is coming from the Fabric side because everything has been tested and troubleshooted however still getting this error

[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

[refh0111]

the driver is installed correctly. We tested the connection to the server from the PC using the driver, and it worked successfully. However, we are still encountering this error in Fabric. 

[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]

the driver is installed correctly. We tested the connection to the server from the PC using the driver, and it worked successfully. However, we are still encountering this error in Fabric. This is an on-premises instance, and the ODBC driver has been directly installed on the SAP server.

[mariodefe]

Hi I believe its complaining for missing HANA driver on your desktop.

You can download the driver from the SAP Portal, follow these two blogs, one from Microsoft and one from SAP.

https://community.fabric.microsoft.com/t5/Desktop/unable-to-connect-SAP-hana/m-p/1179990

https://help.sap.com/docs/SAP_HANA_ACCELERATOR_FOR_SAP_ASE/647582cc310341319e6e8d6f23f1f230/63ee4009...

[refh0111]

I did download the driver, it even suggested the specific driver to download however it seems it can not be discoverable

[refh0111]

@FabianSchut