freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Build issue on AIX (invalid connection)

From: "Worman, Tyler" <tworman AT med.umich.edu>
To: "freetds AT lists.ibiblio.org" <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Build issue on AIX (invalid connection)
Date: Tue, 22 Sep 2015 16:56:26 +0000

I was able to fix this by building GNU libiconv and then build FreeTDS
against that. After that, it runs and connects without the odd "L" error
message. The TDS_DUMP also no longer complains about iconv.

To get libiconv to build I needed to set the following:

export OBJECT_MODE=64
env CC=gcc CFLAGS="-maix64 -I/usr/local/include" AR_FLAGS="-X64 cru"
/configure --prefix=/home/tworman/local64/
make
make install

-----Original Message-----
From: FreeTDS [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of
Sebastien FLAESCH
Sent: Tuesday, September 22, 2015 11:17 AM
To: freetds AT lists.ibiblio.org
Subject: Re: [freetds] Build issue on AIX (invalid connection)

And here is the TDSDUMP (0.95-rc3)...
Seb

On 09/22/2015 05:08 PM, Sebastien FLAESCH wrote:
> Also tested with 0.95-rc3 by the way.
> Seb
>
> On 09/22/2015 05:07 PM, Sebastien FLAESCH wrote:
>> Trying to build 0.95.5 on AIX 6.1 in 64bit mode...
>>
>> $ export OBJECT_MODE=64
>>
>> $ CC="gcc -maix64" CXX="g++ -maix64" LDFLAGS="-maix64" ./configure
>> --prefix=$FTMDIR --with-odbc-nodm=/dbs/64bits/uxo/2.3.1
>>
>> Note that we are using unixODBC 2.3.1, and we don't want to use
>> unixODBC as we link directly with libtdsodbc.a/.so ...
>>
>> A simple connection fails and SQLGetDiagRec() returns a strange error
>> message:
>>
>> SQL State: 42000
>> SQL code : 18456
>> Message : [FreeTDS][SQL Server]L
>>
>> SQL SERVER error 18456 is an invalid user/login issue, but when I
>> switch to an older version of FreeTDS (0.92), same data source +
>> username + login connects without problem...
>>
>> Any ideas?
>>
>> I suspect some unixODBC defines problem...
>>
>> Any way to check that the unixODBC defines (32b/64b SQLLEN) match?
>>
>> sizeof(SQLLEN) = 8
>>
>> Seb
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS AT lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>

**********************************************************
Electronic Mail is not secure, may not be read every day, and should not be
used for urgent or sensitive issues

[freetds] Build issue on AIX (invalid connection), Sebastien FLAESCH, 09/22/2015
- Re: [freetds] Build issue on AIX (invalid connection), Sebastien FLAESCH, 09/22/2015
  - Re: [freetds] Build issue on AIX (invalid connection), Sebastien FLAESCH, 09/22/2015
    - Re: [freetds] Build issue on AIX (invalid connection), Worman, Tyler, 09/22/2015
    - Re: [freetds] Build issue on AIX (invalid connection), Worman, Tyler, 09/22/2015
      - Re: [freetds] Build issue on AIX (invalid connection), Sebastien FLAESCH, 09/23/2015
        
        Re: [freetds] Build issue on AIX (invalid connection), Sebastien FLAESCH, 09/29/2015