1. ODBC 드라이버 설치
# apt-get install unixodbc unixodbc-dev libmyodbc
2. ODBC 설정
# vi /etc/odbcinst.ini
sudo gedit /etc/odbcinst.ini
[MySQL]
Description = MySQL ODBC 5.1 Driver
Driver = /usr/lib/odbc/libmyodbc.so
Setup = /usr/lib/odbc/libodbcmyS.so
FileUsage = 1
# vi /etc/odbc.ini
sudo gedit /etc/odbc.ini
[ODBC Data Sources]
Myodbc = MySQL
[Myodbc]
Description = MySQL ODBC 5.1 Driver
Driver = /usr/lib/odbc/libmyodbc.so
Server = 127.0.0.1
User = username
Password = userpass
Port = 3306
Database = dbname
Socket = /var/run/mysqld/mysql.sock
3. Data source install
# odbcinst –i –s –f /etc/odbc.ini
4. Mysql odbc 드라이버를 /usr/lib 에 복사
# cp /usr/lib/odbc/* /usr/lib
5. ODBC 확인
# odbcinst –j ; odbc 상태정보 확인
unixODBC 2.2.11
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
USER DATA SOURCES..: /root/.odbc.ini
5. DB 연결 테스트
# isql -v myodbc
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>