Linux怎么安装ODBC连接SQLServer数据库

yum install gcc

tar -xvf unixODBC-2.3.9.tar.gzcd unixODBC-2.3.9./configure --prefix=/usr/local/unixODBCmakemake install

tar -xvf freetds-1.3.9.tar.gzcd freetds-1.3.9./configure --prefix=/usr/local/freetds --with-unixodbc=/usr/local/unixODBC/makemake install

[SQLServer]    host = serverip    port = 1433    tds version = 7.3

/usr/local/freetds/bin/tsql -S SQLServer -U saPassword: locale is "zh_CN.UTF-8"locale charset is "UTF-8"using default charset "UTF-8"1>

[FreeTDS]                                         #驱动名称Description=FreeTDS DriverDriver=/usr/local/freetds/lib/libtdsodbc.so     #驱动位置

[mssql]  #DSN名称Description=sqlserver connectionDriver=FreeTDS    #上面配置好的驱动名称TDS_Version=7.3   #TDS驱动版本TRACE=On　　　　#是否输出日志信息TraceFile=stderr  #日志信息的位置Server=serverip  #数据库网络地址Port=1433       #数据库端口User=name       #登录用户名Password=pwd     #密码Database=db name  #连接的数据库名称

/usr/local/unixODBC/bin/isql mssql name pwd+---------------------------------------+| Connected!                            ||                                       || sql-statement                         || help [tablename]                      || quit                                  ||                                       |+---------------------------------------+SQL> select * from sys.objects+---------------------------------------------------------------------------------------------------------------------------------+------------+-------------+------------+-----------------+-----+-------------------------------------------------------------+------------------------+------------------------+--------------+-------------+--------------------+| name                                                                                                                            | object_id  | principal_id| schema_id  | parent_object_id| type| type_desc                                                   | create_date            | modify_date            | is_ms_shipped| is_published| is_schema_published|

SQL="/usr/local/unixODBC/bin/isql mssql sa 123"i_sql=" exec dbo.bulkinsert 10,20,'dbo.stu';    "echo $i_sqlresult=`echo $i_sql|$SQL`

SQL="select * from Student"EMPLOYEES=`isql mssql sa 123 <<EOF   $SQL   go   EOF

echo "$SQL" > $TMP/sql.$$EMPLOYEES=`isql mssql sa 123 -i $TMP/sql.$$`rm $TMP/sql.$$

osql.exe -S ip -U sa -P 123 -d WAI -Q "exec dbo.bulkinsert %start%,%end%,stu