Skip site navigation (1) Skip section navigation (2)

Re: Cannot link to postgres 8.0.0 databases using ODBC from

From: Eric E <whalesuit(at)bonbon(dot)net>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Cannot link to postgres 8.0.0 databases using ODBC from
Date: 2005-02-18 17:51:04
Message-ID: 42162B08.8080008@bonbon.net (view raw or flat)
Thread:
Lists: 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(dot)burrow(at)powerconv(dot)alstom(dot)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
>
>  
>



In response to

pgsql-odbc by date

Next:From: Joel FradkinDate: 2005-02-18 18:25:27
Subject: encoding using the odbc driver
Previous:From: Greg CampbellDate: 2005-02-18 17:22:51
Subject: Re: More Problems with ODBC and Access

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group