[freetds] FreeTDS isql ERROR

Nick Stoughton nick at msbit.com
Wed Jun 16 13:27:59 EDT 2004

On Wed, 2004-06-16 at 15:52, hany heggy wrote:
> hi,
> i have installed unixODBC 2.2.9 under AIX 5.1.5 and driver manger works
> fine with DB driver
The version of the configure/libtool script for freetds is very old, and
does not support shared libraries on AIX (look in ltcf-c.sh). It should
print the following warning:
*** Warning: the GNU linker, at least up to release 2.9.1, is reported
*** to be unable to reliably create shared libraries on AIX.
*** Therefore, libtool is disabling shared libraries support.  If you
*** really care for shared libraries, you may want to modify your PATH
*** so that a non-GNU linker is found, and then restart.

You are going to have  to do some work to allow a shared library to be
> then finally could install freetds-0.62.3 using:
> ./configure --with-unixodbc=/SOFTWARE/unixODBC-2.2.9 --with-tdsver=8.0
> make
> make install
This *should* install libtdsodbc.so if all is well ... but it will fail
on AIX.
> and installed the driver using:
> cd freetds/samples
> ./unixodbc.install.sh
This isn't needed.
> then extract libtdsodbc.so.o shared object:
> cd /usr/local/lib
> ar -vx libtdsodbc.a
This is wrong.
> then configured ODBC files:
> odbc.ini , odbcinst.ini and freetds.confg
These should point to the libtdsodbc.so file installed above.
> when i try isql it gives this error:
> /usr/local/bin>./isql -v dsnname  user password
> [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
> [ISQL]ERROR: Could not SQLConnect
> i contacted Nick at unixODBC and he think it is freetds problem
> any ideas ??
I don't have an AIX box handy to test this on ... but if you have
aversion of gnu ld that is more recent than 2.9.1, you could simply try
removing the case: edit ltcf-c.sh, look for the following test:

  # See if GNU ld supports shared libraries.
  case $host_os in
  aix3* | aix4* | aix5*)

REMOVE the "| aix5*" from this. You will end up falling through to the
default case. If AIX supports ELF binaries, you will get shared
libraries built.
Nick Stoughton <nick at msbit.com>

More information about the FreeTDS mailing list