MSSQL/クライアント

[root@c ~]# yum install unixODBC

[root@c ~]# cat /etc/odbcinst.ini
[PostgreSQL]
Description=ODBC for PostgreSQL
Driver=/usr/lib/psqlodbcw.so
Setup=/usr/lib/libodbcpsqlS.so
Driver64=/usr/lib64/psqlodbcw.so
Setup64=/usr/lib64/libodbcpsqlS.so
FileUsage=1
 
[MySQL]
Description=ODBC for MySQL
Driver=/usr/lib/libmyodbc5.so
Setup=/usr/lib/libodbcmyS.so
Driver64=/usr/lib64/libmyodbc5.so
Setup64=/usr/lib64/libodbcmyS.so
FileUsage=1
[root@c ~]#

[root@c src]# gzip -cd msodbcsql-13.0.0.0.tar.gz | tar xf - && cd msodbcsql-13.0.0.0
[root@c msodbcsql-13.0.0.0]# ./install.sh verify
 
Microsoft ODBC Driver 13 for SQL Server Installation Script
Copyright Microsoft Corp.
 
Starting install for Microsoft ODBC Driver 13 for SQL Server
 
Checking for 64 bit Linux compatible OS ..................................... OK
Checking required libs are installed ........................................ OK
unixODBC utilities (odbc_config and odbcinst) installed ..................... OK
unixODBC Driver Manager version 2.3.1 installed ............................. OK
unixODBC Driver Manager configuration correct .............................. OK*
Microsoft ODBC Driver 13 for SQL Server already installed ............ NOT FOUND
 
Install log created at /tmp/msodbcsql.6886.320.9581/install.log.
 
One or more steps may have an *. See README for more information regarding
these steps.
[root@c msodbcsql-13.0.0.0]#

[root@c msodbcsql-13.0.0.0]# ./install.sh install --accept-license
 
Microsoft ODBC Driver 13 for SQL Server Installation Script
Copyright Microsoft Corp.
 
Starting install for Microsoft ODBC Driver 13 for SQL Server
 
Checking for 64 bit Linux compatible OS ..................................... OK
Checking required libs are installed ........................................ OK
unixODBC utilities (odbc_config and odbcinst) installed ..................... OK
unixODBC Driver Manager version 2.3.1 installed ............................. OK
unixODBC Driver Manager configuration correct .............................. OK*
Microsoft ODBC Driver 13 for SQL Server already installed ............ NOT FOUND
Microsoft ODBC Driver 13 for SQL Server files copied ........................ OK
Symbolic links for bcp and sqlcmd created ................................... OK
Microsoft ODBC Driver 13 for SQL Server registered ................... INSTALLED
 
Install log created at /tmp/msodbcsql.2725.5527.1554/install.log.
 
One or more steps may have an *. See README for more information regarding
these steps.
[root@c msodbcsql-13.0.0.0]#

[root@c ~]# cat /etc/odbcinst.ini
(略)
 
[ODBC Driver 13 for SQL Server]
Description=Microsoft ODBC Driver 13 for SQL Server
Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.0.so.0.0
Threading=1
UsageCount=1
 
[root@c ~]#

[root@c ~]# sqlcmd
Microsoft (R) SQL Server Command Line Tool
Version 13.0.0000.0 Linux
Copyright (c) 2012 Microsoft. All rights reserved.
 
usage: sqlcmd            [-U login id]          [-P password]
  [-S server or Dsn if -D is provided]
  [-H hostname]          [-E trusted connection]
  [-N Encrypt Connection][-C Trust Server Certificate]
  [-d use database name] [-l login timeout]     [-t query timeout]
  [-h headers]           [-s colseparator]      [-w screen width]
  [-a packetsize]        [-e echo input]        [-I Enable Quoted Identifiers]
  [-c cmdend]
  [-q "cmdline query"]   [-Q "cmdline query" and exit]
  [-m errorlevel]        [-V severitylevel]     [-W remove trailing spaces]
  [-u unicode output]    [-r[0|1] msgs to stderr]
  [-i inputfile]         [-o outputfile]
  [-k[1|2] remove[replace] control characters]
  [-y variable length type display width]
  [-Y fixed length type display width]
  [-p[1] print statistics[colon format]]
  [-R use client regional setting]
  [-K application intent]
  [-M multisubnet failover]
  [-b On error batch abort]
  [-D Dsn flag, indicate -S is Dsn]
  [-X[1] disable commands, startup script, environment variables [and exit]]
  [-x disable variable substitution]
  [-? show syntax summary]
[root@c ~]#

[illya@c ~]$ sqlcmd -S fm -Uillya
Password:
1> use sample
2> go
データベース コンテキストが 'sample' に変更されました。
1>
2> exit
[illya@c ~]$

[illya@c ~]$ sqlcmd -S fm -E
Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : SSPI Provider: Server not found in Kerberos database.
Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Cannot generate SSPI context.
[illya@c ~]$

[root@c ~]# cat /etc/odbc.ini
[mssql-sample]
Driver = ODBC Driver 13 for SQL Server
Description = fm sqlserver sample database
SERVER = fm.sybyl.local
DATABASE = sample
[root@c ~]#

[root@c ~]# isql mssql-sample illya illya
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> quit
[root@c ~]#

[root@c ~]# yum install php-odbc

[root@c ~]# cat /tmp/odbc.php
<?php
 
$dbh = new PDO("odbc:mssql-sample", "illya", "illya" );
$sql = "SELECT id FROM TEST_TABLE";
$sth = $dbh->prepare($sql);
$sth->execute();
$res = $sth->fetchAll();
print_r($res);
 
?>
[root@c ~]#