erlang 에서 odbc 사용하기

========================================
cat /etc/odbc.ini
------------------------------------------------------
[myodbc]
Driver = /usr/lib/odbc/libmyodbc.so
Description = MySQL ODBC Driver DSN
SERVER = localhost
PORT    =
USER    =
Password    =
Database    =
OPTION    = 3
SOCKET    =
========================================

========================================
cat /etc/odbcinst.ini
------------------------------------------------------
[MySQL]
Description        = MySQL ODBC Driver
Driver        = /usr/lib/odbc/libmyodbc.so
Setup        = /usr/lib/odbc/libmyodbc.so
UsageCount        = 1
========================================


application:start(odbc).
{ok,Ref} = odbc:connect("DSN=myodbc;UID=root;PWD=myPassword",[]).
odbc:sql_query(Ref,"select version();").
odbc:sql_query(Ref,"use mydatabase;").
odbc:sql_query(Ref,"select * from MyTable;").