공간사랑

UNIXODBC 설치

# wget  ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.0.tar.gz

# tar xvzf unixODBC-2.3.0.tar.gz

# CPPFLAGS="-DSIZEOF_LONG_INT=8"

# export CPPFLAGS

# ./configure --prefix=/usr --libdir=/usr/lib64 --sysconfdir=/etc --enable-gui=no --enable-drivers=no --enable-iconv --with-iconv-char-enc=UTF8 --with-iconv-ucode-enc=UTF16LE

# make

# make install

--------------------------------------------------

Linux 기반 Microsoft ODBC Driver 11 for SQL Server 설치

https://msdn.microsoft.com/ko-kr/library/hh568454(v=sql.110).aspx

# tar xvzf msodbcsql-11.0.2270.0.tar.gz

# ./install.sh

# odbc_config --odbcinstini

# vi /etc/odbcinst.ini 파일 수정

[SQL Server Native Client 11.0]
Description=Microsoft ODBC Driver 11 for SQL Server
Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2270.0
Threading=1
UsageCount=1

#  ./install.sh verify

#  ./install.sh install

#  odbcinst -q -d -n "ODBC Driver 11 for SQL Server".

--------------------------------------------------

# tar sqlncli-11.0.1790.0.tar.gz

# ./install.sh

# odbc_config --odbcinstini

# vi /etc/odbcinst.ini 파일 수정

[SQL Server Native Client 11.0]
Description=Microsoft SQL Server ODBC Driver V1.0 for Linux
Driver=/opt/microsoft/sqlncli/lib64/libsqlncli-11.0.so.1790.0
Threading=1
UsageCount=2

#  ./install.sh verify

#  ./install.sh install

#  odbcinst -q -d -n "SQL Server Native Client 11.0".

참고

http://hsunryou.blog.me/220167436452
 

https://blogs.msdn.microsoft.com/sqlblog/2012/01/26/use-existing-msdn-c-odbc-samples-for-microsoft-linux-odbc-driver/

Microsoft® SQL Server® ODBC Driver 1.0 for Linux

https://www.microsoft.com/en-us/download/details.aspx?id=28160

https://docs.microsoft.com/en-us/sql/odbc/reference/syntax/sqlbindcol-function