FreeTDS Development Group

[Frediano Ziglio <freddy77 AT gmail.com>]

2011/1/19 Jean Jordaan <jean.jordaan AT gmail.com>:
> Hi there
>
> Could anyone possibly give me any insights regarding this?
> I'd be very grateful to become unwedged on this issue ..
>
> pims@dweb66:~$ ODBCSYSINI=/home/pims isql -vvv FinanceDB
> [IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on
> SQL_HANDLE_HENV failed
> [ISQL]ERROR: Could not SQLConnect
>
> I have to specify ODBCSYSINI as I'm not root on this box.
>
> pims@dweb66:~$ cat odbc.ini
> [FinanceDB]
> Driver=FreeTDS
> Description=Finance database
> Server=1.2.3.4
> Port=3010
> Database=report
> User=user
> Password=pass
>
> pims@dweb66:~$ cat odbcinst.ini
> [FreeTDS]
> Description=FreeTDS Driver for Sybase and MSSQL
> Driver=/usr/lib/libtds.so.5
> Setup=/usr/lib/libtdsS.so
>
> This is on a RedHat system.
>
> --
> jean                                              . .. .... //\\\oo///\\

You should use a libtdsodbc.so, do not use libtds.so !!!

freddy77