none
Connect SQL 2017 with Active Directory Authentication using VBA Code RRS feed

  • Question

  • Hi , I would like to connect with SQL 2017 using Active directory authentication with Visual Basic (VBA) Code. Is below piece of code is the right way to setup connectivity in this case: 

                           "Driver={ODBC Driver 17 for SQL Server};" & _
                            "Server=xxx.database.windows.net;" & _
                            "Database=xxx;" & _
                            "Authentication=ActiveDirectoryIntegrated;" & _
                            "Encrypt=yes;Connection Timeout=30;"

    Regards

    Monday, May 13, 2019 11:53 AM