[edit]
설치 #
☞ unixodbc 설치
./configure --prefix=/usr/local/odbc --sysconfdir=/etc --enable-drivrs=yes --enable-gui=no
make ; make install ;
☞ freetds 설치
./configure --prefix=/usr/local/freetds --with-unixodbc=/usr/local/odbc
make ; make install ;
☞1> freetds.conf 수정
.....
.....
[sql151]
host = xxx.xxx.xxx.151
port = 1433
tds version = 8.0
☞ tds.driver.template 드라이버 파일의 설정
[freeTDS]
Description = v0.52 with protocol v4.2
Driver = /usr/local/freetds/lib/libtdsodbc.so
☞ odbcinst -i -d -f tds.driver.template
☞ tds.datasource.template
[idc151]
Driver = freeTDS
Description = IDC 151 svr
Trace = No
Servername = sql151
Database = PSERP
☞ odbcinst -i -s -f tds.datasource.template
☞ /etc/odbcinst.ini 화일
[ORACLE]
Description = Easysoft ODBC Oracle Driver
Driver = /usr/local/easysoft/oracle/libesoracle.so
Setup = /usr/local/easysoft/oracle/libesoraclesetup.so
FileUsage = 1
[FreeTDS]
Description = FreeTDS unixODBC Driver
Driver = /usr/local/freetds/lib/libtdsodbc.so
UsageCount = 1
☞ freeTDS 의 테스트
- tsql -H sql151 -p 1433 -U sa
- tsql -S idc151 -U sa
- unixodbc 에서 테스트
/usr/local/odbc/bin/isql -v idc151 sa MyPassword
Test tsql of FreeTDS, e.g.:
tsql -S Kana -U 'username' -P 'password'
locale is "C"
locale charset is "646"
1> use Northwind
2> go
1> select * from mies
2> go
aap
mies
1>quit
Test isql of unixODBC:
isql -v Kana 'username' 'password'
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> select * from mies;
+-----------+
| aap |
+-----------+
| mies |
+-----------+
SQLRowCount returns 1
1 rows fetched
SQL> quit
