# Pdo\_sqlsrv and pdo\_odbc **URL:** \ **Category:** Web\ **Created:** [August 24, 2024, 3:20pm UTC](https://forum.hestiacp.com/t/pdo-sqlsrv-and-pdo-odbc/15615 "2024-08-24T15:20:31Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Travis](https://forum.hestiacp.com/letter_avatar_proxy/v4/letter/t/bbce88/32.png) [@Travis](https://forum.hestiacp.com/u/Travis)\ **Post date:** [August 24, 2024, 3:20pm UTC](https://forum.hestiacp.com/t/pdo-sqlsrv-and-pdo-odbc/15615/1 "2024-08-24T15:20:31Z")
Hi guys, I am using Debian 12 and just installed HestiaCP. How to install pdo\_odbc and pdo\_sqlsrv for php 8.3 to send queries to mssql from Laravel application? Thanks for you time! I really appreciate ---
**Author:** ![eris](https://forum.hestiacp.com/user_avatar/forum.hestiacp.com/eris/32/1241_2.png) [@eris](https://forum.hestiacp.com/u/eris)\ **Post date:** [August 24, 2024, 3:41pm UTC](https://forum.hestiacp.com/t/pdo-sqlsrv-and-pdo-odbc/15615/2 "2024-08-24T15:41:25Z")
> [@Travis](#): > > pdo\_odbc apt install php8.3-odbc php8.3-sqlsrv ---
**Author:** ![Travis](https://forum.hestiacp.com/letter_avatar_proxy/v4/letter/t/bbce88/32.png) [@Travis](https://forum.hestiacp.com/u/Travis)\ **Post date:** [August 24, 2024, 5:04pm UTC](https://forum.hestiacp.com/t/pdo-sqlsrv-and-pdo-odbc/15615/3 "2024-08-24T17:04:51Z")
> [@eris](#): > > apt install php8.3-odbc php8.3-sqlsrv root@host:~# apt install php8.3-odbc php8.3-sqlsrv Reading package lists… Done Building dependency tree… Done Reading state information… Done E: Unable to locate package php8.3-sqlsrv E: Couldn’t find any package by glob ‘php8.3-sqlsrv’ root@host:~# root@host:~# root@host:~# ---
**Author:** ![sahsanu](https://forum.hestiacp.com/user_avatar/forum.hestiacp.com/sahsanu/32/9318_2.png) [@sahsanu](https://forum.hestiacp.com/u/sahsanu)\ **Post date:** [August 24, 2024, 5:25pm UTC](https://forum.hestiacp.com/t/pdo-sqlsrv-and-pdo-odbc/15615/4 "2024-08-24T17:25:57Z")
To install sqlsrv you should follow the instructions on this page (Steps 2 and 3): > **[Linux and macOS Installation for the Drivers for PHP - PHP drivers for SQL...](https://learn.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver16)** > > In these instructions, learn how to install the Microsoft Drivers for PHP for SQL Server on Linux or macOS. **Note** : I’ve never installed them nor will try to do it. ---
**Author:** ![Travis](https://forum.hestiacp.com/letter_avatar_proxy/v4/letter/t/bbce88/32.png) [@Travis](https://forum.hestiacp.com/u/Travis)\ **Post date:** [August 24, 2024, 5:28pm UTC](https://forum.hestiacp.com/t/pdo-sqlsrv-and-pdo-odbc/15615/5 "2024-08-24T17:28:04Z")
sudo: pecl: command not found ---
**Author:** ![sahsanu](https://forum.hestiacp.com/user_avatar/forum.hestiacp.com/sahsanu/32/9318_2.png) [@sahsanu](https://forum.hestiacp.com/u/sahsanu)\ **Post date:** [August 24, 2024, 5:30pm UTC](https://forum.hestiacp.com/t/pdo-sqlsrv-and-pdo-odbc/15615/6 "2024-08-24T17:30:12Z")
You must install `php-pear` ---
**Author:** ![Travis](https://forum.hestiacp.com/letter_avatar_proxy/v4/letter/t/bbce88/32.png) [@Travis](https://forum.hestiacp.com/u/Travis)\ **Post date:** [August 24, 2024, 5:35pm UTC](https://forum.hestiacp.com/t/pdo-sqlsrv-and-pdo-odbc/15615/7 "2024-08-24T17:35:39Z")
root@host:~# sudo pecl install sqlsrv WARNING: channel “[pecl.php.net](http://pecl.php.net)” has updated its protocols, use “pecl channel-update [pecl.php.net](http://pecl.php.net)” to update downloading sqlsrv-5.12.0.tgz … Starting to download sqlsrv-5.12.0.tgz (193,767 bytes) …done: 193,767 bytes 34 source files, building running: phpize sh: 1: phpize: not found ERROR: `phpize’ failed ---
**Author:** ![sahsanu](https://forum.hestiacp.com/user_avatar/forum.hestiacp.com/sahsanu/32/9318_2.png) [@sahsanu](https://forum.hestiacp.com/u/sahsanu)\ **Post date:** [August 24, 2024, 5:43pm UTC](https://forum.hestiacp.com/t/pdo-sqlsrv-and-pdo-odbc/15615/8 "2024-08-24T17:43:22Z")
Change `php8.2-dev` by the php version you are using. ```t sudo apt install php-pear gcc make autoconf libc-dev pkg-config libreadline-dev php8.2-dev sudo pecl channel-update pecl.php.net ``` ---
**Author:** ![Travis](https://forum.hestiacp.com/letter_avatar_proxy/v4/letter/t/bbce88/32.png) [@Travis](https://forum.hestiacp.com/u/Travis)\ **Post date:** [August 24, 2024, 5:47pm UTC](https://forum.hestiacp.com/t/pdo-sqlsrv-and-pdo-odbc/15615/9 "2024-08-24T17:47:57Z")
anyway root@host:~# sudo pecl install sqlsrv WARNING: channel “[pecl.php.net](http://pecl.php.net)” has updated its protocols, use “pecl channel-update [pecl.php.net](http://pecl.php.net)” to update downloading sqlsrv-5.12.0.tgz … Starting to download sqlsrv-5.12.0.tgz (193,767 bytes) …done: 193,767 bytes 34 source files, building running: phpize sh: 1: phpize: not found ERROR: `phpize’ failed ---
**Author:** ![sahsanu](https://forum.hestiacp.com/user_avatar/forum.hestiacp.com/sahsanu/32/9318_2.png) [@sahsanu](https://forum.hestiacp.com/u/sahsanu)\ **Post date:** [August 24, 2024, 6:02pm UTC](https://forum.hestiacp.com/t/pdo-sqlsrv-and-pdo-odbc/15615/10 "2024-08-24T18:02:17Z")
> [@Travis](#): > > WARNING: channel “[pecl.php.net](http://pecl.php.net)” has updated its protocols, use “pecl channel-update [pecl.php.net](http://pecl.php.net)” to update As I said above: This is solved using: ```t sudo pecl channel-update pecl.php.net ``` > [@Travis](#): > > sh: 1: phpize: not found This is solved installing the dev package for the php version you are using on your system. ```t sudo apt install php-pear gcc make autoconf libc-dev pkg-config libreadline-dev php8.2-dev ``` ---
**Author:** ![Travis](https://forum.hestiacp.com/letter_avatar_proxy/v4/letter/t/bbce88/32.png) [@Travis](https://forum.hestiacp.com/u/Travis)\ **Post date:** [August 24, 2024, 6:03pm UTC](https://forum.hestiacp.com/t/pdo-sqlsrv-and-pdo-odbc/15615/11 "2024-08-24T18:03:57Z")
Anyway Starting to download sqlsrv-5.12.0.tgz (193,767 bytes) …done: 193,767 bytes 34 source files, building running: phpize sh: 1: phpize: not found ERROR: `phpize’ failed ---
**Author:** ![Travis](https://forum.hestiacp.com/letter_avatar_proxy/v4/letter/t/bbce88/32.png) [@Travis](https://forum.hestiacp.com/u/Travis)\ **Post date:** [August 24, 2024, 6:04pm UTC](https://forum.hestiacp.com/t/pdo-sqlsrv-and-pdo-odbc/15615/12 "2024-08-24T18:04:46Z")
Also for some reason in the Hestia settings I can’t make 8.3 php primary. In general settings → server. 8.2 is displayed last, although I have 8.3 as well ---
**Author:** ![sahsanu](https://forum.hestiacp.com/user_avatar/forum.hestiacp.com/sahsanu/32/9318_2.png) [@sahsanu](https://forum.hestiacp.com/u/sahsanu)\ **Post date:** [August 24, 2024, 6:05pm UTC](https://forum.hestiacp.com/t/pdo-sqlsrv-and-pdo-odbc/15615/13 "2024-08-24T18:05:32Z")
But are you installing the php dev package for your default php version? ```t php -v ``` ---
**Author:** ![Travis](https://forum.hestiacp.com/letter_avatar_proxy/v4/letter/t/bbce88/32.png) [@Travis](https://forum.hestiacp.com/u/Travis)\ **Post date:** [August 24, 2024, 6:06pm UTC](https://forum.hestiacp.com/t/pdo-sqlsrv-and-pdo-odbc/15615/14 "2024-08-24T18:06:15Z")
> [@sahsanu](#): > > `php -v` PHP 8.2.22 (cli) (built: Aug 2 2024 16:01:44) (NTS) But i am using 8.3 for my Laravel app ---
**Author:** ![eris](https://forum.hestiacp.com/user_avatar/forum.hestiacp.com/eris/32/1241_2.png) [@eris](https://forum.hestiacp.com/u/eris)\ **Post date:** [August 24, 2024, 6:08pm UTC](https://forum.hestiacp.com/t/pdo-sqlsrv-and-pdo-odbc/15615/15 "2024-08-24T18:08:09Z")
use php8.3 instead ---
**Author:** ![sahsanu](https://forum.hestiacp.com/user_avatar/forum.hestiacp.com/sahsanu/32/9318_2.png) [@sahsanu](https://forum.hestiacp.com/u/sahsanu)\ **Post date:** [August 24, 2024, 6:08pm UTC](https://forum.hestiacp.com/t/pdo-sqlsrv-and-pdo-odbc/15615/16 "2024-08-24T18:08:18Z")
```auto sed -i '/^\t"php-8.2",/a \\t"php-8.3",' /usr/local/hestia/web/edit/server/index.php v-change-sys-php 8.3 ``` ---
**Author:** ![Travis](https://forum.hestiacp.com/letter_avatar_proxy/v4/letter/t/bbce88/32.png) [@Travis](https://forum.hestiacp.com/u/Travis)\ **Post date:** [August 24, 2024, 6:08pm UTC](https://forum.hestiacp.com/t/pdo-sqlsrv-and-pdo-odbc/15615/17 "2024-08-24T18:08:48Z")
root@host:~# sed -i ‘/^\t"php-8.2",/a \t"php-8.3",’ /usr/local/hestia/web/edit/server/index.php root@host:~# v-change-sys-php 8.3 update-alternatives: using /usr/bin/php8.3 to provide /usr/bin/php (php) in manual mode root@host:~# ---
**Author:** ![Travis](https://forum.hestiacp.com/letter_avatar_proxy/v4/letter/t/bbce88/32.png) [@Travis](https://forum.hestiacp.com/u/Travis)\ **Post date:** [August 24, 2024, 6:09pm UTC](https://forum.hestiacp.com/t/pdo-sqlsrv-and-pdo-odbc/15615/18 "2024-08-24T18:09:31Z")
root@host:~# sudo pecl install sqlsrv downloading sqlsrv-5.12.0.tgz … Starting to download sqlsrv-5.12.0.tgz (193,767 bytes) …done: 193,767 bytes 34 source files, building running: phpize sh: 1: phpize: not found ERROR: `phpize’ failed root@host:~# php -v PHP 8.3.10 (cli) (built: Aug 2 2024 16:00:00) (NTS) Copyright (c) The PHP Group Zend Engine v4.3.10, Copyright (c) Zend Technologies with Zend OPcache v8.3.10, Copyright (c), by Zend Technologies root@host:~# ---
**Author:** ![sahsanu](https://forum.hestiacp.com/user_avatar/forum.hestiacp.com/sahsanu/32/9318_2.png) [@sahsanu](https://forum.hestiacp.com/u/sahsanu)\ **Post date:** [August 24, 2024, 6:17pm UTC](https://forum.hestiacp.com/t/pdo-sqlsrv-and-pdo-odbc/15615/19 "2024-08-24T18:17:47Z")
The last commands configured php 8.3 as your default version, Did you install php8.3-dev ? ```t sudo apt install php-pear gcc make autoconf libc-dev pkg-config libreadline-dev php8.3-dev ``` ---
**Author:** ![Travis](https://forum.hestiacp.com/letter_avatar_proxy/v4/letter/t/bbce88/32.png) [@Travis](https://forum.hestiacp.com/u/Travis)\ **Post date:** [August 24, 2024, 6:32pm UTC](https://forum.hestiacp.com/t/pdo-sqlsrv-and-pdo-odbc/15615/20 "2024-08-24T18:32:20Z")
Thank your sir. Guys, can you tell me what is the correct path if i’m not use apache2? I’m talking about this: printf “; priority=20\nextension=sqlsrv.so\n” \> /etc/php/8.1/mods-available/sqlsrv.ini printf “; priority=30\nextension=pdo\_sqlsrv.so\n” \> /etc/php/8.1/mods-available/pdo\_sqlsrv.ini just /etc/php? [Next page](https://forum.hestiacp.com/t/pdo-sqlsrv-and-pdo-odbc/15615.md?page=2)