I am using this connection string to connect to an Azure SQL database from inside Excel and everything works fine because I have installed Microsoft's OLE DB
driver.
I was wondering if it is possible to connect without installing this driver? I have many users that should do it and it is not practical to ask IT for many installations. The users themselves are not a local admin on their Windows 10 so I am looking for a workaround
'connection string (azure)
Public Const sConnectionStringAzure = "Provider=MSOLEDBSQL;" & _
"DataTypeCompatibility=80;" & _
"Server=tcp:myserver.database.windows.net,1433;" & _
"Database=mydatabase;" & _
"Uid=BasicUser@myserver;" & _
"Pwd={abc};" & _
"Encrypt=yes;Connection Timeout=30;"
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…