# Install driver odbc pour Sql Server

**URL:** <https://www.debian-fr.org/t/install-driver-odbc-pour-sql-server/81866>\
**Category:** Support Debian\
**Created:** [Avril 21, 2020, 4:24 UTC](https://www.debian-fr.org/t/install-driver-odbc-pour-sql-server/81866 "2020-04-21T16:24:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![razer](https://www.debian-fr.org/letter_avatar_proxy/v4/letter/r/c77e96/32.png) [@razer](https://www.debian-fr.org/u/razer)\
**Post date:** [Avril 21, 2020, 4:24 UTC](https://www.debian-fr.org/t/install-driver-odbc-pour-sql-server/81866/1 "2020-04-21T16:24:56Z")

</div>

Bonjour à tous,

J’ai installer une nouvelle vm avec la dernier version debian :  
root@srv-intranet:~# lsb\_release -a  
No LSB modules are available.  
Distributor ID: Debian  
Description: Debian GNU/Linux 10 (buster)  
Release: 10  
Codename: buster  
Linux srv-intranet 4.19.0-8-686-pae #1 SMP Debian 4.19.98-1 (2020-01-26) i686 GNU/Linux

```
root@srv-intranet:~# odbcinst -j
unixODBC 2.3.6
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 4
SQLLEN Size........: 4
SQLSETPOSIROW Size.: 2

```

Et je bloque pour installer les drivers obdc de MS pour acceder à sqlserver

Au travers des différents tuto, il indique de passer la commande: pecl install sqlsrv mais a la fin j’ai cette erreur:

```auto
    In file included from /tmp/pear/temp/sqlsrv/shared/xplat.h:99,
                     from /tmp/pear/temp/sqlsrv/shared/typedefs_for_linux.h:23,
                     from /tmp/pear/temp/sqlsrv/shared/xplat_winnls.h:24,
                     from /tmp/pear/temp/sqlsrv/shared/FormattedPrint.h:24,
                     from /tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:41,
                     from /tmp/pear/temp/sqlsrv/php_sqlsrv_int.h:25,
                     from /tmp/pear/temp/sqlsrv/conn.cpp:24:
    /tmp/pear/temp/sqlsrv/shared/xplat_intsafe.h:50:29: error: conflicting declaration ‘typedef windowsULong_t DWORD’
     typedef windowsULong_t DWORD;
                                 ^ ~~~~
    In file included from /usr/include/sql.h:19,
                     from /tmp/pear/temp/sqlsrv/shared/xplat.h:30,
                     from /tmp/pear/temp/sqlsrv/shared/typedefs_for_linux.h:23,
                     from /tmp/pear/temp/sqlsrv/shared/xplat_winnls.h:24,
                     from /tmp/pear/temp/sqlsrv/shared/FormattedPrint.h:24,
                     from /tmp/pear/temp/sqlsrv/shared/core_sqlsrv.h:41,
                     from /tmp/pear/temp/sqlsrv/php_sqlsrv_int.h:25,
                     from /tmp/pear/temp/sqlsrv/conn.cpp:24:
    /usr/include/sqltypes.h:96:24: note: previous declaration as ‘typedef long unsigned int DWORD’
     typedef unsigned long DWORD;
                            ^ ~~~~
    make: *** [Makefile:194: conn.lo] Error 1
    ERROR: `make' failed

```

en recherchant sur internet il indique que cela peut provenir d’une valeur dans le fichier /user/include/unixodbc\_conf.h mais je n’ai pas ce fichier. Celui est présent dans " /usr/include/i386-linux-gnu/unixodbc\_conf.h"  
(Passage de la valeur de 4 à 8)

```
#ifndef SIZEOF_LONG_INT
define SIZEOF_LONG_INT 8
#endif

```

Mais cela ne fonctionne pas.

Et donc je me permet de venir vers vous car je ne sais pas ou regarder maintenant

merci d’avance pour vos conseils

---

<div class="post-metadata">

**Author:** ![Clochette](https://www.debian-fr.org/user_avatar/www.debian-fr.org/clochette/32/8757_2.png) [@Clochette](https://www.debian-fr.org/u/Clochette)\
**Post date:** [Avril 21, 2020, 5:29 UTC](https://www.debian-fr.org/t/install-driver-odbc-pour-sql-server/81866/2 "2020-04-21T17:29:16Z")

</div>

les drivers disponible dans les dépôts ne conviennent pas à tes besoins ?

[https://packages.debian.org/search?keywords=tdsodbc](https://packages.debian.org/search?keywords=tdsodbc)