Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save cruzmayra/038f4213e2f6d854f58c4ac6cb0c3505 to your computer and use it in GitHub Desktop.
Save cruzmayra/038f4213e2f6d854f58c4ac6cb0c3505 to your computer and use it in GitHub Desktop.
Install the Microsoft ODBC driver for SQL Server (ubuntu 20.04)
sudo add-apt-repository ppa:ondrej/php
sudo apt install php7.3 php7.3-{cli,common,curl,dev,json,opcache,readline,xml,xsl,mbstring,zip,gd,mysql}
sudo su
curl https://packages.microsoft.com/config/ubuntu/19.10/prod.list > /etc/apt/sources.list.d/mssql-release.list
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
Ctrl + D
sudo apt update
sudo su
ACCEPT_EULA=Y apt install msodbcsql17
sudo ACCEPT_EULA=Y apt-get install mssql-tools
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
sudo apt-get install unixodbc-dev
Ctrl + D
sudo pecl install -f sqlsrv
sudo pecl install -f pdo_sqlsrv
sudo su
printf "; priority=20\nextension=sqlsrv.so\n" > /etc/php/7.3/mods-available/sqlsrv.ini
printf "; priority=30\nextension=pdo_sqlsrv.so\n" > /etc/php/7.3/mods-available/pdo_sqlsrv.ini
phpenmod -v 7.3 sqlsrv pdo_sqlsrv
// puedes probar que todo funciona con tinker (php)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment