Discussion :

[ouldfella]

Bonjour,
pour résoudre cette erreur j'ai du installer odbc avec :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
sudo apt-get update
sudo apt-get install php-odbc

mais je recois toujour l'erreur et quand je tape php -v je reçois ce message :

:/etc/php# php -v
PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_mysql' (tried: /usr/lib/php/20180731/pdo_mysql (/usr/lib/php/20180731/pdo_mysql: cannot open shared object file: No such file or directory), /usr/lib/php/20180731/pdo_mysql.so (/usr/lib/php/20180731/pdo_mysql.so: undefined symbol: mysqlnd_allocator)) in Unknown on line 0
PHP Warning: Module 'curl' already loaded in Unknown on line 0
PHP Warning: Module 'mbstring' already loaded in Unknown on line 0
PHP 7.3.33-1+ubuntu20.04.1+deb.sury.org+1 (cli) (built: Nov 19 2021 06:25:05) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.33, Copyright (c) 1998-2018 Zend Technologies
with Zend OPcache v7.3.33-1+ubuntu20.04.1+deb.sury.org+1, Copyright (c) 1999-2018, by Zend Technologies

[ouldfella]

bonjour,
maintenant je suis arrivé à cette erreur :

Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 17 for SQL Server' : file not found, SQL state 01000 in SQLConnect in /var/www/html/app/db/connectPDOSQLSERVER.php on line 17
[unixODBC][Driver Manager]Can't open lib 'ODBC Driver 17 for SQL Server' : file not found
Warning: odbc_exec() expects parameter 1 to be resource, bool given in /var/www/html/content/ctrls/admins/auto/Extract.Ctrl.class.php on line 31

Warning: odbc_fetch_array() expects parameter 1 to be resource, null given in /var/www/html/content/ctrls/admins/auto/Extract.Ctrl.class.php on line 35

[ouldfella]

j'ai appliqué ce script :

sudo ln -s /usr/local/etc/odbc.ini /etc/odbc.ini
sudo ACCEPT_EULA=Y apt-get install -y mssql-tools
sudo apt-get install -y unixodbc-dev

rien ne marche