Once you've downloaded the driver, follow these steps to install it:
Driver=SQL Server Native Client 10.0; Server=192.168.1.100,1433; Database=SalesDB; Uid=myUser; Pwd=myPass; Encrypt=yes; microsoft sql server native client 10.0 odbc driver download
: For new projects, Microsoft strongly recommends switching to the Microsoft ODBC Driver for SQL Server (currently version 18). Once you've downloaded the driver, follow these steps