Problems connecting from ODBC to Azure SQlL private endpoint

Copper Contributor

Hi All

 

I am in the process of setting up a few new laptops for our data team and we've encountered something odd.

I have a Azure SQL database with a Private Endpoint configured to make the database accessible over P2S VPN.

On old laptops the database is accessible via Azure Data Studio, SSMS and ODBC. Power Bi cannot directly but works with ODBC. 

On the new laptops the database is accessible via Azure Data Studio, SSMS but not ODBC

 

The old laptops required an entry on the hosts file

I'm stumped on this. I've checked a variety of networks setting to find something.

 

Any thoughts hive mind

1 Reply
I would think that it may be due to the resolution of the name to IP. Can you set the same hosts entry on the new laptops?

Also what is the version of ODBC on the old laptops and the new laptops? Same?