FreeTDS Development Group

["Worman, Tyler" <tworman AT med.umich.edu>]

Hi,
 Trying to build FreeTDS (stable .95.19) on AIX 7100-03-05-1524. The .so 
files don't generate. Browsed online and tried a few suggested fixes for 
similar problems but no luck so far. Generated my own .so files from the .a 
that builds but it doesn't seem to work. Any advice? 

Using the following:
./configure --with-unixodbc=/usr/local/ --prefix=/home/tworman/local 
--with-tdsver=7.0
make
make install

Appears to complete but no .so files are generated in the directory 
/home/tworman/local/lib. I only get .a and .la files.
I tested tsql that was built. It worked and connected to my MS SQL Server 
instance fine. 

I then generated the .so from the .a with gcc -fpic -g -shared -o 
libtdsodbc.so libtdsodbc.a
I verified my config using osql. It's fine until it gets to the actual 
connection and invoking isql (Unixodbc 32-bit).
I tried the exact same .odbc.ini from a Linux box with a build of FreeTDS 
there and it works fine.

The OSQL test:
./osql -S TEST -U accthere -P passwordhere

That produces this but no dump. 
[IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV 
failed
[ISQL]ERROR: Could not SQLConnect
sed: Cannot find or open file /tmp/osql.dump.51511686.

If I do this instead, I still get no dump, and nothing is written to the file 
I specify.
TDSDUMPCONFIG=stderr TDSDUMP=~/local/bin/temp ./osql -S TEST -U usernamhere 
-P passwordhere

Thanks!

     - Tyler






Semi-unrelated try of 64 bit build (even though UnixODBC is compiled with 
32bit types).
export OBJECT_MODE=64
export CFLAGS=-maix64 
export LIBPATH=/usr/local/lib
export LD_LIBRARY_PATH=/usr/local/lib
export AR_FLAGS="-X64 cru" 
export ARFLAGS="-X64 cru"
./configure --with-tdsver=7.0 --with-unixodbc=/usr/local 
--prefix=/home/tworman/local

Configure is fine but build of this fails with:
Making all in .
  CC       odbc.lo
odbc.c: In function '_SQLRowCount':
odbc.c:4630: warning: visibility attribute not supported in this 
configuration; ignored
  CC       connectparams.lo
connectparams.c:96: error: static declaration of 'SQLGetPrivateProfileString' 
follows non-static declaration
/usr/local/include/odbcinst.h:210: error: previous declaration of 
'SQLGetPrivateProfileString' was here
make: The error code from the last command is 1.
Stop.
make: The error code from the last command is 1.
Stop.
make: The error code from the last command is 2.
Stop.
make: The error code from the last command is 1.
Stop.
make: The error code from the last command is 1.
Stop.

Not sure if this is really the path I should go down. This seems like I just 
have multiple libraries defining SQLGetPrivateProfileString but I only see 
one in my library path. That is the one from unixodbc at /usr/local/include/
**********************************************************
Electronic Mail is not secure, may not be read every day, and should not be 
used for urgent or sensitive issues