Re: Communication error during authentication

Hi Peter-san.

Um , it is strange?_?

My test as below.

inet% iodbctest DSN=PostgreSQLA
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0406.0126
Driver: 08.03.0100 (psqlodbca.so)

SQL>SELECT usename FROM pg_user;

usename
----------------------------------------------------------------
saito

 result set 1 returned 1 rows.


SQL>

-- odbc.ini --
[PostgreSQLA]
Driver          = /usr/home/saito/PSQLODBC/psqlodbc/.libs/psqlodbca.so
FetchBufferSize = 99
Description     = PostgreSQL ODBC driver
Host            = localhost
UserName        = saito
Password        =
Database        = saito
SSLmode = prefer
#SSLmode = disable
ServerOptions   =
ConnectOptions  =
Options         =
ReadOnly        = no
RowVersioning   = no
ShowSystemTables= no
ShowOidColumn   = no
FakeOidIndex    = no
Debug           = 1

...probably, mylog may be helpful. 

Regards,
Hiro**** Saito

----- Original Message ----- 
From: "Peter Eisentraut" <peter_e@[EMAIL PROTECTED]
>
To: <pgsql-odbc@[EMAIL PROTECTED]
>
Sent: Monday, February 04, 2008 8:46 PM
Subject: [ODBC] Communication error during authentication


>I am attempting to upgrade from 08.01.0200 to 08.03.0100.  I have
attached my 
> odbcinst.ini and .odbc.ini.  Connecting from psql and the old ODBC
driver 
> works fine, but the new one gives me "Communication error during 
> authentication" with the identical configuration and build options.  The

> driver log is attached.  How can I debug this?
> 
> -- 
> Peter Eisentraut
> http://developer.postgresql.org/~petere/
>


--------------------------------------------------------------------------------


> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>               http://www.postgresql.org/docs/faq
>

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend