VBA ADO and Azure Sql server

[nd0911]

Hello,

first I want to say that, I'm very new with Azure and Sql server.
second, I have an VBA ADO code with a simple select query from an Azure SQL SERVER db.

On my main PC (the PC with my SSMS that i use to contacat the sql server) the code works perfect, but on any other PC (I used the same file in the same IP newwork) I get an error message: "Micosoft ODBC driver manager - Data source name not found and no default driver specified"
I thought that this is an IP rule so i added in the azure portal a firewall rule with 0.0.0.0 to 255.255.255.255 just to test and still no luck.
this is the connection string I'm useing in my ADO, maybe this is the problem ?

[COLOR=#2B91AF]
[/COLOR]Private Function GetSqlServerConnectionString() As String
GetSqlServerConnectionString = "Driver={SQL Server Native Client 11.0};" _
                            & "Server=tcp:xxxxxxxx.database.windows.net,1433;" _
                            & "Database=xxxxx;" _
                            & "Uid=xxxxxxx;" _
                            & "Pwd={xxxxxxxx};" _
                            & "Encrypt=yes;" _
                            & "Connection Timeout=30;"
End Function
[COLOR=#2B91AF]
[/COLOR]

Does anyone have any idea about this issue ?

thank you !!