View Single Post

   
  #2 (permalink)  
Old 04-17-2008, 04:27 PM
Hiroshi Saito
 
Posts: n/a
Default 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,
Hiroshi Saito

----- Original Message -----
From: "Peter Eisentraut" <peter_e@gmx.net>
To: <pgsql-odbc@postgresql.org>
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

Reply With Quote