Forum Discussion
Lakehouse Connection issue using SQL Endpoint
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.comRedircted URL : pbipneu9-northeurope.pbidedicated.windows.net\ABCDUL5IRFUEJGEUFNEEFOKTJM-CCSJOZJPH6FE5GFNZMCN4ILWLA-dw:1433
Existing code logic trying to connect : pbipneu9-northeurope.pbidedicated.windows.net
Hi Pratik_0527 ,
If you are trying to connect to SQL endpoint using a C++ app,
you have to use REST API and the supported features for it are
Items - REST API (SQLEndpoint) | Microsoft Learn
whereas for lakehouse these are the supported features
Items - REST API (Lakehouse) | Microsoft Learn
If this post helps, then please consider Accepting as solution to help the other members find it more quickly and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank you
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.
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.