I had a install problem of installing unixODBC(http://www.unixodbc.org/) on my Fedora4.
After I installed the unixODBC by ./configure and make and make install.
And then I edit the odbc.ini and odbcinst.ini.
odbcinst -i -d -f odbcinst.ini
odbcinst -i -s -f odbc.ini -l
The content is my odbcinst.ini
[unixODBC]
Driver=/usr/local/lib/libodbc.so
Setup=/usr/local/lib/libodbc.so
Threading=0
FileUsage=1
DontDLClose=1
UsageCount=3
The content is my odbc.ini
[DNS]
Driver=unixODBC
Description=unixODBC
Server=XXX.XXX.XX.XXX
Port=XXXX
Database=XXXX
User=XXXXX
Password=XXXXX
Mars_Connection=No
Logging=No
LogFile=
QuotedId=Yes
AnsiNPW=Yes
Language=
Version7=No
ClientLB=No
Failover_Partner=
VarMaxAsLong=No
DisguiseWide=No
DisguiseLong=No
DisguiseGuid=No
Trusted_Connection=No
Trusted_Domain=
IPv6=No
But when I run isql -v DNS in /usr/cloal/etc directory
It appear the error as below:
[root@localhost etc]# isql -v DNS
[IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
My MS SQL is 2008, the unixODBC support the MS SQL Server 2008?