This is a multi-part message in MIME format.
--------------020006020404060103020703
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
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 sup****ts 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@[EMAIL PROTECTED]
> http://www.blueface.ie
|
+-------------------------------------------------------+
--------------020006020404060103020703
Content-Type: text/plain;
name="trace.log"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="trace.log"
[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
--------------020006020404060103020703
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
--------------020006020404060103020703--
|
