转载请注明:http://blog.csdn.net/fuqiangnxn/article/details/53844501
第一步:配置unixODBC,请看http://blog.csdn.net/fuqiangnxn/article/details/53841754
第二步:安装mysql odbc驱动程序
下载地址:http://dev.mysql.com/downloads/connector/odbc/
tar xzvf mysql-connector-odbc-5.3.7-linux-el7-x86-64bit.tar.gz
cd mysql-connector-odbc-5.3.7-linux-el7-x86-64bit
mkdir $HOME/local/mysql/odbc
cp lib/libmyodbc5.so $HOME/local/mysql/odbc
第三步:配置驱动环境
cd $ODBCSYSINI
vi odbcinst.ini 输入如下内容
[mysql]
Description = MySQL ODBC 5.1 Driver
Driver = /.../local/mysql/odbc/libmyodbc5.so
Setup = /.../local/mysql/odbclibmyodbc3S.so
UsageCount = 1
CPTimeout = 5
CPReuse = 5
FileUsage = 1
vi$ODBCINI 输入如下内容
[mysqltest]
Driver = mysql
Description = mysql test
Server = //ip
Database = //basename
Port = 3306
socket = /.../mysql/mysql.sock //应该可以不写
以上环境全部配置完毕,使用isql测试连接
isql mysql username passwd -v
第四步:source修改
#include <sql.h>
#include <sqlext.h>
SQLConnect中的dsn写为odbc.ini中配置的DSN。
编译链接:
gcc -g -o test_odbc -I$HOME/local/unixODBC/include -L$HOME/local/unixODBC/lib -lodbc test_odbc.c