Re: Struggling to connect to Sybase

Frediano Ziglio <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
2011/1/19 Jean Jordaan <[email protected]>:
> 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
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.