Re: ODBC Version supporting specif databases?

Hi Luiz,

I have attached the trace.log and there seems to be an issue in
SQLAllocHandle.c.

I tried to enable commlog and debug but i cant seem to find the files
that they are meant to generate. Just to verify, do I add the following
parameters to the dsn in odbc.ini?

Debug = 1
CommLog = 1

Thanks
Bruce

Luiz K. Matsumura wrote:
> Hi Bruce
>
> I guess that you need first enable Mylog and commlog and send both files
> to the list.
> This will help to trace the source code for errors.
>
>
> Bruce McAlister wrote:
>> Hi All,
>>
>> Does anyone have any ideas/tips on how I could further debug this
>> problem?
>>
>> Thanks
>> Bruce
>>
>> Bruce McAlister wrote:
>>> Hi All,
>>>
>>> I am having connection issues with the 08.03.0100 version of the ODBC
>>> driver.
>>>
>>> What happens is that when I attempt to connect to an 8.2.6 PostgreSQL
>>> database, using the 08.3.0100 ODBC driver then i get an error
>>> connecting during authentication as follows:
>>>
>>> -------------------------------------------------------------------------
>>>
>>> [28000][unixODBC]Communication error during authentication;
>>> Error while reading from the socket.
>>> [ISQL]ERROR: Could not SQLConnect
>>> -------------------------------------------------------------------------
>>>
>>>
>>> However, if I use the 08.01.0200 version to connect to the same DSN,
>>> I am able to successfully connect?
>>>
>>> Is there a specific version of the ODBC driver that supports a
>>> specific version of the PostgreSQL database.
>>>
>>> The way the above two ODBC drivers were built are as follows:
>>>
>>> OS: Solaris 10 Update 3
>>> ODBC Manager : unixODBC v1.2.12
>>>
>>> I'm not too sure which version of the libpq library was used, but I
>>> know for certain that Solaris 10 Update 3 comes with a Sun built
>>> version of PostgreSQL 8.1, the one on the system I am trying to build
>>> on is version 8.1.10.
>>>
>>> Am I doing something wrong or are the versions of the odbc driver
>>> just not compatible with the versions of libpq that i am using to
>>> build with, and thus, unable to connect to the database, or, is it
>>> something completely different.
>>>
>>> If you need any additional info, please dont hesitate to ask.
>>>
>>> Thanks
>>> Bruce
>>
>

--
+-------------------------------------------------------+
| Bruce McAlister                          Blueface Ltd |
| <bruce.mcalister@blueface.ie>  http://www.blueface.ie |
+-------------------------------------------------------+
[ODBC][7248][__handles.c][447]
        Exit:[SQL_SUCCESS]
            Environment = 8067ac0
[ODBC][7248][SQLAllocHandle.c][358]
        Entry:
            Handle Type = 2
            Input Handle = 8067ac0
[ODBC][7248][SQLAllocHandle.c][476]
        Exit:[SQL_SUCCESS]
            Output Handle = 80680e8
[ODBC][7248][SQLConnect.c][3586]
        Entry:
            Connection = 80680e8
            Server Name = [blueface-services][length = 17 (SQL_NTS)]
            User Name = [NULL]
            Authentication = [NULL]
        UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

[ODBC][7248][SQLAllocHandle.c][331]Error: SQL_INVALID_HANDLE
[ODBC][7248][SQLConnect.c][1570]Error: IM005
[ODBC][7248][SQLError.c][476]Error: SQL_INVALID_HANDLE
[ODBC][7248][SQLError.c][424]
        Entry:
            Connection = 80680e8
            SQLState = 8047a00
            Native = 80479fc
            Message Text = 8047a10
            Buffer Length = 500
            Text Len Ptr = 80479fa
[ODBC][7248][SQLError.c][461]
        Exit:[SQL_SUCCESS]
            SQLState = IM005
            Native = 80479fc -> 0
            Message Text = [[unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed]
[ODBC][7248][SQLError.c][424]
        Entry:
            Connection = 80680e8
            SQLState = 8047a00
            Native = 80479fc
            Message Text = 8047a10
            Buffer Length = 500
            Text Len Ptr = 80479fa
[ODBC][7248][SQLError.c][461]
        Exit:[SQL_NO_DATA]
[ODBC][7248][SQLError.c][504]
        Entry:
            Environment = 8067ac0
            SQLState = 8047a00
            Native = 80479fc
            Message Text = 8047a10
            Buffer Length = 500
            Text Len Ptr = 80479fa
[ODBC][7248][SQLError.c][541]
        Exit:[SQL_NO_DATA]
[ODBC][7248][SQLFreeHandle.c][273]
        Entry:
            Handle Type = 2
            Input Handle = 80680e8
[ODBC][7248][SQLFreeHandle.c][188]Error: SQL_INVALID_HANDLE
[ODBC][7248][SQLFreeHandle.c][324]
        Exit:[SQL_SUCCESS]
[ODBC][7248][SQLFreeHandle.c][206]
        Entry:
            Handle Type = 1
            Input Handle = 8067ac0