Re: Cannot link to postgres 8.0.0 databases using ODBC from - Mailing list pgsql-odbc

From Eric E
Subject Re: Cannot link to postgres 8.0.0 databases using ODBC from
Date
Msg-id 42162B08.8080008@bonbon.net
Whole thread Raw
In response to Re: Cannot link to postgres 8.0.0 databases using ODBC from  (laurie.burrow@powerconv.alstom.com)
List pgsql-odbc
Laurie,
    I'm thinking these lines in the log may be of interest:

[unknown] [unknown]  2005-02-17 18:55:59 4214e8bf.9dc 0LOCATION:
BackendRun, postmaster.c:2656

and

ldb rjl_pilot 10.35.10.248(4630) 2005-02-17 18:55:59 4214e8bf.9dc
0LOCATION:  log_disconnections, postgres.c:3403

I'd try turning off log_discconnections, and see if you get any joy.  If
that works and the log still displays problems
related to BackendRun, I'd email the pg-hackers list.

EE

laurie.burrow@powerconv.alstom.com wrote:

>Further investigation of the problem I described in my previous posting has
>identified a fault that I suppose is applicable to the combination of
>Postgres 8.0.0 ODBC driver running on Windows 2000 server and desktop.
>
>I have two postgresql.conf files, one is the default out-of-the-box
>postgresql.conf file, the other has many of the logging options turned on
>(I have put the diff between the two files at the end)
>
>The default config works fine, the modified config fails in that the
>postgres ODBC does not work (tested with Access 97,2000 and Perl ODBC
>connections) giving the error "The database does not exist on the server or
>user authentication failed. (#105)".
>
>Only ODBC seems to be affected. All other connections from php, pgadmin
>work fine.
>
>I have demonstrated this problem consistently on two completely different
>and brand new installations of P8.0.0 (W2K server and desktop). I have not
>been able to pin down exactly what combination of settings generates the
>error.
>
>Regards
>Laurie
>
>
>The diff of the two config files is
>
>207a208
>
>
>>client_min_messages = log
>>
>>
>212a214
>
>
>>log_min_messages=info
>>
>>
>214a217
>
>
>>log_error_verbosity = verbose
>>
>>
>218a222
>
>
>>log_min_error_statement = info
>>
>>
>230a235
>
>
>>log_connections = true
>>
>>
>231a237
>
>
>>log_disconnections = true
>>
>>
>232a239
>
>
>>log_duration = true
>>
>>
>240a248,249
>
>
>>log_line_prefix = '%u %d %r %t %c %x'
>>
>>
>>
>241a251
>
>
>>log_statement = 'all'
>>
>>
>
>
>
>:.________________
>CONFIDENTIALITY : This  e-mail  and  any attachments are confidential and
>may be privileged. If  you are not a named recipient, please notify the
>sender immediately and do not disclose the contents to another person, use
>it for any purpose or store or copy the information in any medium.
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
>
>
>



pgsql-odbc by date:

Previous
From: "Greg Campbell"
Date:
Subject: Re: More Problems with ODBC and Access
Next
From: "Joel Fradkin"
Date:
Subject: encoding using the odbc driver