Advertisement

unxiODBC install problem

Started by July 10, 2010 01:39 AM
-1 comments, last by akira32 14 years, 6 months ago
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?
akira32 編程之家 Yahoohttp://tw.myblog.yahoo.com/akira32-akira32

This topic is closed to new replies.

Advertisement