Re: ODBC Version supporting specif databases?

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.