连接mssql报错, 通过odbc

[蜡笔小新啦]

我连接mssql 通过odbc，在linux redhat 64bit。
----> below is odbc and freetds configuration files.
------- freetds.conf--------------
[FreeTDS]
host=172.21.32.20
port=1433
tds version=7.2
client charset = GB2312
------------ odbcinst.ini-----------------
[TDS]
Description = TDS
Driver = /usr/local/lib/libtdsodbc.so
Trace = Yes
TraceFile=/tmp/odbcinst.log
UsageCount = 1
------------- odbc.ini -----------------
[SQLSERVER]
Driver = TDS
Description = sql server dsn
Trace = NO
Server = 172.21.32.20
Database = Live
Port = 1433
TDS_Version = 7.2
TraceFile=/tmp/sqlserver.log

----------------------- snippets ---------------------------
QString f3ErpDsn = QString::fromLocal8Bit("Driver={SQLSERVER};server=172.21.32.20;database=Live;uid=inp;pwd=inp;");
QSqlDatabase f3ErpDb= QSqlDatabase::addDatabase("QODBC");
f3ErpDb.setDatabaseName(f3ErpDsn);
// f3ErpDb.setDatabaseName("SQLSERVER");
f3ErpDb.setUserName("inp");
f3ErpDb.setPassword("inp");
QString sqlCmdStr = "select * from dbo.Table_Drilling_Data01 where status=1";
if ( ! f3ErpDb.open() )
{
qDebug() << f3ErpDb.lastError().text();
return 1;
}
QSqlTableModel model;
model.setTable("dbo.Table_Drilling_Data01");
model.setFilter("status=3");
model.select();
qDebug() << model.lastError().text();

----------------- error messages
1. "f3ErpDb.setDatabaseName(f3ErpDsn);"
当我设置setDatabaseName 为 f3ErpDsn.
错误信息是 : "QODBC3: Unable to connect", "[unixODBC][Driver Manager]Data source name not found, and no default driver specified")
我已经定义SQLSERVER在odbc.ini中，为什么他还是报错呢？

2. 如果我改成 "f3ErpDb.setDatabaseName("SQLSERVER");"
error message is : "[FreeTDS][SQL Server]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 (""): Data type 0x00 is unknown. QODBC3: Unable to execute statement"
这又是为什么呢？


thanks
ken

[蜡笔小新啦]

没人知道吗？

[蜡笔小新啦]

人呢？人都哪里去了？