Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS isql ERROR

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Nick Stoughton <nick AT msbit.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS isql ERROR
  • Date: Wed, 16 Jun 2004 10:27:59 -0700

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
built.
>
> 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>





Archive powered by MHonArc 2.6.24.

Top of Page