谁用过unixODBC呀?
SXSXY 2003-08-21 11:34:26 由于需要在linux下访问SQL Server 2000数据库,就安装了unixODBC和FreeTDS。可是却无法与远程的数据库连接。
FreeTDS的配置文件
/usr/local/etc/freetds.conf内容如下:
#----------------------------------
[mssql]
host = remote host
port = 1433
tds version = 8.0
#-----------------------------------
unixODBC的配置文件
/usr/local/etc/odbcinst.ini内容如下:
#-----------------------------------
[SQLServer]
Description = SQL Server driver 2000
Driver = /usr/local/lib/libtdsodbc.so
#------------------------------------
/usr/local/etc/odbc.ini内容如下:
#------------------------------------
[mssql]
Description =SQL Server
Driver =SQLServer
Trace =No
Database =MyDB
Servername =remote host
UserName =MyUserName
Password =MyPWD
Port =1433
#-------------------------------------
配置完毕后,我用它自带的isql测试了一下,却发现无法连接。
# isql -v mssql MyUserName MyPWD
[S1000][unixODBC]Client unable to establish connection
[ISQL]ERROR: Could not SQLConnect
请问这该如何解决呢?