SEO

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 |
+-------------------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Woops, the unixODBC version below should read 2.2.12, not 1.2.12.

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 |
+-------------------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

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 |
+-------------------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

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
>

--
Luiz K. Matsumura
Plan IT Tecnologia Informática Ltda.


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

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


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster