{"id":331,"date":"2025-01-02T11:53:02","date_gmt":"2025-01-02T04:53:02","guid":{"rendered":"https:\/\/prosindo.com\/blog\/?p=331"},"modified":"2025-10-04T21:21:55","modified_gmt":"2025-10-04T14:21:55","slug":"install-php-odbc-in-ubuntu","status":"publish","type":"post","link":"https:\/\/prosindo.com\/blog\/2025\/01\/02\/install-php-odbc-in-ubuntu\/","title":{"rendered":"Install PHP ODBC in Ubuntu"},"content":{"rendered":"\n

only support ubuntu 18.04 20.04 22.04<\/p>\n\n\n\n

sudo apt update
sudo apt install gnupg<\/code><\/p>\n\n\n\n

sudo curl https:\/\/packages.microsoft.com\/keys\/microsoft.asc | apt-key add -
sudo curl https:\/\/packages.microsoft.com\/config\/ubuntu\/$(lsb_release -rs)\/prod.list > \/etc\/apt\/sources.list.d\/mssql-release.list
sudo apt update
sudo ACCEPT_EULA=Y apt-get install -y msodbcsql18
sudo ACCEPT_EULA=Y apt-get install -y mssql-tools18
echo 'export PATH=\"$PATH:\/opt\/mssql-tools18\/bin\"' >> ~\/.bashrc
source ~\/.bashrc
sudo apt-get install -y unixodbc-dev
sudo apt install php-odbc
sudo service apache2 restart
cat \/etc\/odbcinst.ini
configure driver name specified in odbcinst above<\/code><\/p>\n\n\n\n

#example\n$odbc = odbc_connect('DRIVER={ODBC Driver 18 for SQL Server};SERVER=<server>;DATABASE=<db>;TrustServerCertificate=yes', 'sa', '<password>');<\/code><\/pre>\n\n\n\n
sqlcmd -S host -U user -P pass -C<\/code><\/p>\n\n\n\n
\n
Note: TrustServerCertificate is required, else it will get ssl error<\/p>\n<\/blockquote>\n\n\n\n
https:\/\/learn.microsoft.com\/en-us\/sql\/connect\/odbc\/linux-mac\/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver16&tabs=ubuntu18-install%2Calpine17-install%2Cdebian8-install%2Credhat7-13-install%2Crhel7-offline<\/p>\n\n\n\n
for ubuntu 24.04:
sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys EB3E94ADBE1229CF<\/code>
sudo mkdir -p \/etc\/apt\/keyrings
curl -fsSL https:\/\/packages.microsoft.com\/keys\/microsoft.asc | sudo gpg --dearmor -o \/etc\/apt\/keyrings\/microsoft.gpg
sudo nano \/etc\/apt\/sources.list.d\/microsoft-prod.list
deb [arch=amd64 signed-by=\/etc\/apt\/keyrings\/microsoft.gpg] https:\/\/packages.microsoft.com\/ubuntu\/24.04\/prod noble main<\/code><\/p>\n\n\n\n
ssl provider: unsupported protocol
odbc 18 not support older sql server, because it requires tls1.2+ (sql 2014\/older)
upgrade to sql server 2008 sp4, windows KB4057114, or use odbc 13<\/p>\n\n\n\n
odbc 17 not support ubuntu 24.04, use driver for 22.04 seems fine
\/etc\/apt\/sources.list.d\/mssql-release.list
deb [arch=amd64 signed-by=\/etc\/apt\/keyrings\/microsoft.gpg] https:\/\/packages.microsoft.com\/ubuntu\/22.04\/prod jammy main<\/code><\/p>\n\n\n\n
odbc 13 only support ubuntu 16.04 or lower, proxmox only support container ubuntu 20.04 or higher, need to install on vm<\/p>\n\n\n\n
alternatively use freetds, with encryption = off in \/etc\/freetds\/freetds.conf
use tsql to confirm
tsql -S <host> -U <user> -P <password><\/code>
tsql -H <host> -p 1433 -D master -U <user> -P <password><\/code><\/p>\n\n\n\n
use odbc – freetds in php not support parameterized query
$odbc = odbc_connect(\"Driver=FreeTDS;Server=<host>;Port=1433; Database=<db>;Encryption=off\", \"<user>\", \"<password>\");<\/code><\/p>\n\n\n\n
use pdo – odbc – freetds to fix it
$dsn = 'odbc:Driver=FreeTDS;Server=<host>;Port=1433;Database=<db>; Encryption=off';<\/code>
$pdo = new PDO($dsn, $username, $password, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);<\/code>
<\/p>\n","protected":false},"excerpt":{"rendered":"
only support ubuntu 18.04 20.04 22.04 sudo apt updatesudo apt install gnupg sudo curl https:\/\/packages.microsoft.com\/keys\/microsoft.asc | apt-key add -sudo curl https:\/\/packages.microsoft.com\/config\/ubuntu\/$(lsb_release -rs)\/prod.list > \/etc\/apt\/sources.list.d\/mssql-release.listsudo apt updatesudo ACCEPT_EULA=Y apt-get install -y msodbcsql18sudo ACCEPT_EULA=Y apt-get install -y mssql-tools18echo ‘export PATH=”$PATH:\/opt\/mssql-tools18\/bin”‘ >> ~\/.bashrcsource ~\/.bashrcsudo apt-get install -y unixodbc-devsudo apt install php-odbcsudo service apache2 restartcat \/etc\/odbcinst.iniconfigure driver name specified … Continue reading “Install PHP ODBC in Ubuntu”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-331","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/prosindo.com\/blog\/wp-json\/wp\/v2\/posts\/331","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prosindo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prosindo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prosindo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prosindo.com\/blog\/wp-json\/wp\/v2\/comments?post=331"}],"version-history":[{"count":10,"href":"https:\/\/prosindo.com\/blog\/wp-json\/wp\/v2\/posts\/331\/revisions"}],"predecessor-version":[{"id":496,"href":"https:\/\/prosindo.com\/blog\/wp-json\/wp\/v2\/posts\/331\/revisions\/496"}],"wp:attachment":[{"href":"https:\/\/prosindo.com\/blog\/wp-json\/wp\/v2\/media?parent=331"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prosindo.com\/blog\/wp-json\/wp\/v2\/categories?post=331"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prosindo.com\/blog\/wp-json\/wp\/v2\/tags?post=331"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}