Pdo_sqlsrv and pdo_odbc

[Travis]

done with ```
sudo phpenmod -v 8.3 sqlsrv pdo_sqlsrv

But still could not find driver error

[Travis]

I restarted php-fpm for PHP 8.3 and now another error:

SQLSTATE[IMSSP]: This extension requires the Microsoft ODBC Driver for SQL Server to communicate with SQL Server. Access the following URL to download the ODBC Driver for SQL Server for x64: System requirements - PHP drivers for SQL Server | Microsoft Learn (Connection:

Does anyone have any idea how to fix this? I would be very grateful for advice or help

[Travis]

I think i need to install this extensions for working with Microsoft SQL Server Version 17.
((( i hate this mssql oh my god

[sahsanu]

@Travis

I think i need to install this extensions for working with Microsoft SQL Server Version 17.

If you read the instructions, in the link I’ve posted, in Step 2, you will see a link to install Microsoft ODBC Driver for SQL Server

[Travis]

Unfortunately it doesn’t work for me.

Building dependency tree… Done
Reading state information… Done
E: Unable to locate package msodbcsql17

[Travis]

@eris

apt install php8.3-odbc php8.3-sqlsrv

I did it.

Now how do I install sqlsrv and odbc so php starts seeing them?

[sahsanu]

@Travis

Unfortunately it doesn’t work for me.

Are you sure you follow all the instructions to install ODBC 17 for your operating system?. Did you add the right repository?

[Travis]

Yep. For Debian 12, and all commands below

But now i’m getting an error SQLSTATE[IMSSP]: This extension requires the Microsoft ODBC Driver for SQL Server to communicate with SQL Server. Access the following URL to download the ODBC Driver for SQL Server for x64: System requirements - PHP drivers for SQL Server | Microsoft Learn (Connection: in my laravel app

[sahsanu]

If you followed all the instructions and it doesn’t work I’m afraid I can’t help. But, are you sure you installed all you need?

php -m | grep -E 'odbc|sqls'

Also, did you restart php 8.3?

systemctl restart php8.3-fpm

[Travis]

@sahsanu

php -m | grep -E 'odbc|sqls'

root@host:~# systemctl restart php8.3-fpm
root@host:~#
root@host:~#
root@host:~#
root@host:~#
root@host:~# php -m | grep -E ‘odbc|sqls’
odbc
pdo_sqlsrv
sqlsrv
root@host:~#

[Travis]

Now im getting an new error

SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:0A00014D:SSL routines::legacy sigalg disallowed or unsupported]

[sahsanu]

Well, the extensions are installed, the problem seems the SSL communication between your Laravel app and the MSSQL Server, one of them doesn’t like the signature algorithm used. I don’t know if it is because you must use the last ODBC Driver version (18 instead of 17) or you must use any older version.

[Travis]

Yeah. I’m need to use 17 version cuz the mssql itself version 12.

So me need to change /etc/openssl.conf looks like

[Travis]

Guys! Can you tell me please is that possible to downgrade to odbc 13?