Posted by Andrew B. Collier on 2018-02-05.
Setting up the requisites to access a SQL Server database from Ubuntu.
- Add key.
- Add the location of the repository.
- Update the package list.
- Install the
PATH=$PATH:/opt/mssql-tools/bin as the last line of
Connect to your server.
What driver was installed?
You’ll need the driver string (in this case
ODBC Driver 17 for SQL Server) if you are connecting to the server from R.