wiki-data/sistemas/servidores/linux/odbc.md

Instalación Ms ODBC version 17

 curl https://packages.microsoft.com/keys/microsoft.asc | sudo tee /etc/apt/trusted.gpg.d/microsoft.asc

Debian 12

 curl -fsSL https://packages.microsoft.com/keys/microsoft.asc | sudo gpg --dearmor -o /usr/share/keyrings/microsoft-prod.gpg
 curl https://packages.microsoft.com/config/debian/12/prod.list | sudo tee /etc/apt/sources.list.d/mssql-release.list
 apt-get update
 ACCEPT_EULA=Y apt-get install -y msodbcsql17

optional: for bcp and sqlcmd

 ACCEPT_EULA=Y apt-get install -y mssql-tools
 echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
 source ~/.bashrc

optional: for unixODBC development headers

 apt-get install -y unixodbc-dev

optional: kerberos library for debian-slim distributions

 apt-get install -y libgssapi-krb5-2

Configuramos el ODBC

 mcedit /etc/odbc.ini
 
 [ODBC Data Sources]
 gaia = libmsodbcsql
 
 [gaia]
 Driver = /opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.10.so.6.1 
 server = 192.168.5.150

Probamos la conexion

 isql -v gaia sa 1351
 
 +---------------------------------------+
 | Connected!                            |
 |                                       |
 | sql-statement                         |
 | help [tablename]                      |
 | echo [string]                         |
 | quit                                  |
 |                                       |
 +---------------------------------------+
 SQL>

Obtenemos los ed_registrados y los guardamos en Descargas

 /opt/mssql-tools/bin/bcp "Select id, nombre, apellido, usuario, clave, email, telefono, direccion, documento, ocupacion, estado, fecha_alta, noCorreo from web.dbo.ed_registrados" queryout /home/eduardo/Descargas/ed_registrados.tsv -S "192.168.5.150" -c -t "\t"  -C UTF-8 -k -U sa -P 1351