Forum Discussion

Pratik_0527's avatar
Pratik_0527
Helper I
1 year ago
Solved

Lakehouse Connection issue using SQL Endpoint

Hi All,   Im trying to connect to Fabric Lakehouse through a C++ using the SQL Endpoint. I have registered the APP in Azzure and generated a client ID. Using this to connect im getting below error....
Data Warehouse
Warehouse
  • Pratik_0527's avatar
    Pratik_0527
    1 year ago

    Hi v-nmadadi-msft , We found the solution for the issue. For lakehouse, the connection gets rerouted to some different URL. Initially we were tokenizing it and trying to connect to it, but the trick is you need to perform socket , prelogin on the original end point and "send the redirected URL to the login stage" while using the TDS protocol. PFB sample :
    original Sql end point : nkttul5irfuejgeufneefoktjm-obtyxdfizvlura7ao2yincxurq.datawarehouse.fabric.microsoft.com

    Redircted URL : pbipneu9-northeurope.pbidedicated.windows.net\ABCDUL5IRFUEJGEUFNEEFOKTJM-CCSJOZJPH6FE5GFNZMCN4ILWLA-dw:1433

    Existing code logic trying to connect : pbipneu9-northeurope.pbidedicated.windows.net

Pratik_0527's avatar
Pratik_0527
Helper I
1 year ago

Hi,

 

Thanks for the revert, Let us take a look at this REST API usage and feasibility in our code setup. We will surely try it and update with our findings.

v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
1 year ago

Hi Pratik_0527 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.


Thank you.