Forum Discussion

turagittech63's avatar
turagittech63
Copper Contributor
Mar 30, 2022

Problems connecting from ODBC to Azure SQlL private endpoint

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

Sort By
  • Ben_Miller_DBADuck's avatar
    Ben_Miller_DBADuck
    MVP
    May 31, 2022
    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?

Resources