我在从我的arm linux板查询远程MSSQL数据库时遇到问题。
我编译了unixODBX和FreeTDS，将所有文件复制到arm板上，路径与编译它们的Ubuntu机器中的路径相同。
我还为Ubuntu机器编译了所有东西。
在Ubuntu机器中，我可以用tsql和isql连接和查询数据库。
在arm板中，我只能用tsql连接和查询，而不能用isql。
为UBUNTU机器中的ARM板编译：
unixODBX:
./configure --prefix=/usr/local/unixodbc-arm --host=arm-linux
make
make install
我删除了/usr/local/unixodbc arm/bin/odbc配置，否则我无法编译它。
免费电话：
./configure --prefix=/usr/local/freetds-arm --with-unixodbc=/usr/local/unixodbc-arm --host=arm-linux --disable-libiconv
make
make all
我使用了——禁用libiconv，因为没有这个选项就无法工作。
然后我将“bin”、“lib”和“etc”目录中的文件复制到arm板上，路径与Ubuntu机器中的相同。
/usr/local/unixodbc-arm/bin
/usr/local/unixodbc-arm/lib
/usr/local/unixodbc-arm/etc
/usr/local/freetds-arm/bin
/usr/local/freetds-arm/lib
/usr/local/freetds-arm/etc
配置文件如下：
freetds.conf版本：
root@ok335x:/# cat /usr/local/freetds-arm/etc/freetds.conf
# $Id: freetds.conf,v 1.12 2007-12-25 06:02:36 jklowden Exp $
#
# This file is installed by FreeTDS if no file by the same on a multi-user system
# name is found in the installation directory.
#
# For information about the layout of this file and its settings,
# see the freetds.conf manpage "man freetds.conf".
# Global settings are overridden by those in a database
# server specific section
[global]
# TDS protocol version
; tds version = 4.2
# Whether to write a TDSDUMP file for diagnostic purposes
# (setting this to /tmp is insecure on a multi-user system)
; dump file = /tmp/freetds.log
; debug flags = 0xffff
# Command and connection timeouts
; timeout = 10
; connect timeout = 10
# If you get out-of-memory errors, it may mean that your client
# is trying to allocate a huge buffer for a TEXT field.
# Try setting 'text size' to a more reasonable limit
text size = 64512
# A typical Sybase server
[egServer50]
host = symachine.domain.com
port = 5000
tds version = 5.0
# A typical Microsoft server
[egServer70]
host = ntmachine.domain.com
port = 1433
tds version = 7.0
# Microsoft SQL Server
[SQLEXPRESS]
host = 192.168.0.195
port = 1433
tds version = 7.0
client charset = UTF-8
root@ok335x:/#
odbcinst.ini号：
root@ok335x:/# cat /usr/local/unixodbc-arm/etc/odbcinst.ini
[FreeTDS]
Description=TDS driver (Sybade/MS SQL)
Driver=/usr/local/freetds-arm/lib/libtdsodbc.so
UsageCount=2
root@ok335x:/#
odbc.ini文件
root@ok335x:/# cat /usr/local/unixodbc-arm/etc/odbc.ini
[SQLEXPRESS]
Description = Test to FreeTDS
Driver = FreeTDS
Trace = Yes
TraceFile = sql.log
Database = gti
Servername = SQLEXPRESS
UserName = gti_monitor
Password = gti_monitor
Port = 1433
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =
root@ok335x:/#
tsql配置：
root@ok335x:/# tsql -C
Compile-time settings (established with the "configure" script)
Version: freetds vdev.0.99.134
freetds.conf directory: /usr/local/freetds-arm/etc
MS db-lib source compatibility: no
Sybase binary compatibility: no
Thread safety: yes
iconv library: no
TDS version: 5.0
iODBC: no
unixodbc: yes
SSPI "trusted" logins: no
Kerberos: no
OpenSSL: no
GnuTLS: no
root@ok335x:/#
odbcinst配置：
root@ok335x:/# odbcinst -j
unixODBC 2.3.4
DRIVERS............: /usr/local/unixodbc-arm/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/unixodbc-arm/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/unixodbc-arm/etc/ODBCDataSources
USER DATA SOURCES..: /home/root/.odbc.ini
SQLULEN Size.......: 4
SQLLEN Size........: 4
SQLSETPOSIROW Size.: 2
root@ok335x:/#
运行tsql:
root@ok335x:/# tsql -S SQLEXPRESS -U gti_monitor -P gti_monitor
locale is "C"
locale charset is "ANSI_X3.4-1968"
using default charset "UTF-8"
1> select * from pressures
2> go
id datetime press1 press2
NULL NULL 1 2
(1 row affected)
1> quit
root@ok335x:/#
运行isql：
root@ok335x:/# isql SQLEXPRESS gti_monitor gti_monitor -v
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[ISQL]ERROR: Could not SQLConnect
root@ok335x:/#
这两个命令都在Ubuntu机器上使用相同的配置文件。
有人能帮忙吗？
非常感谢你。
最佳答案
从isql手册页。。。
isql DSN[用户[密码]][选项]
DSN公司。数据源名称，应用于与数据库建立连接。数据源按此顺序在/etc/odbc.ini和$HOME/.odbc.ini文件中查找，后者将覆盖前者。
带有-S的Tsql正在使用freetds.conf文件。但是看起来odbc.ini文件在/usr/local/unixodbc arm/etc/odbc.ini中