Skip to Content.
Sympa Menu

freetds - Re: [freetds] Struggling to connect to Sybase

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Struggling to connect to Sybase
  • Date: Wed, 19 Jan 2011 13:22:18 +0100

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




Archive powered by MHonArc 2.6.24.

Top of Page