错误连接Erlang和mysql odbc

问题描述：

我有一个亚马逊Linux实例，我已经在其上安装了一个名为ejabberd的服务器它里面我有一个用erlang编写的代码（db.erl）。错误连接Erlang和mysql odbc

-module(db). 
-export([connection/0]). 
connection()-> 
odbc:start(), 
ConnectionString = "DSN=qaz;UID=root;PWD=abc", 
{ok, Ref} = odbc:connect(ConnectionString, []), 
Ref.

但当我这个代码是要运行，我得到一个错误

[error] gen_server myapp terminated with reason: no match of right hand 
value {error,"[unixODBC][Driver Manager]Can't open lib 
'/usr/lib/libmyodbc5.so' : file not found SQLSTATE IS: 01000 Connection to 
database failed."} in db:connection/0 line 15 

10:34:15.111 [error] CRASH REPORT Process myapp with 0 neighbours exited 
with reason: no match of right hand value {error,"[unixODBC][Driver 
Manager]Can't open lib '/usr/lib/libmyodbc5.so' : file not found SQLSTATE 
IS: 01000 Connection to database failed."} in db:connection/0 line 15 in 
gen_server:terminate/7 line 812 

10:34:15.111 [error] Supervisor frequency_sup had child myapp started with 
myapp:start() at <0.502.0> exit with reason no match of right hand value 
{error,"[unixODBC][Driver Manager]Can't open lib '/usr/lib/libmyodbc5.so' : 
file not found SQLSTATE IS: 01000 Connection to database failed."} in 
db:connection/0 line 15 in context child_terminated

我已经编辑我的/etc/odbc.ini和/root/.odbc.ini具有以下配置

[ODBC Data Sources] 
qaz= ODBC for MySQL 



[qaz] 
Driver  = /usr/lib64/libmyodbc5.so 
Description = ODBC for MySQL 
SERVER  = localhost 
PORT  = 3306 
USER  = root 
Password = abc 
Database = mydb

和我的ODBCINST.INI文件看起来像这样

# Example driver definitions 

# Driver from the postgresql-odbc package 
# Setup from the unixODBC package 
[PostgreSQL] 
Description = ODBC for PostgreSQL 
Driver  = /usr/lib/psqlodbc.so 
Setup  = /usr/lib/libodbcpsqlS.so 
Driver64 = /usr/lib64/psqlodbc.so 
Setup64  = /usr/lib64/libodbcpsqlS.so 
FileUsage = 1 


# Driver from the mysql-connector-odbc package 
# Setup from the unixODBC package 
[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 

[MySQL ODBC 5.3 Unicode Driver] 
Driver   = /usr/lib/libmyodbc5w.so 
UsageCount    = 1 

[MySQL ODBC 5.3 ANSI Driver] 
Driver   = /usr/lib/libmyodbc5a.so 
UsageCount    = 1

当我运行命令

isql qaz [root [abc]]

我得到一个错误的

[ISQL]ERROR: Could not SQLConnect

谁能告诉我这个问题，并引导我，建立在Linux ODBC配置我已经做了正确的方法它在Windows上成功，但我不太熟悉Linux。预先感谢您

答

这是由mySQL提供的ODBC驱动程序（ODBC连接器）。你是否预先安装了驱动程序？搜索如何安装mysql odbc驱动程序。

但是，我会建议使用另一个mysql驱动程序，如mysql/otp，而不是ODBC驱动程序。我在mySql中使用ODBC驱动程序时遇到了问题。

错误连接Erlang和mysql odbc

相关推荐