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

Re: BUG #5063: MS Access crashes by quiting after linking tables with PostgreSQL

From: Matt Taylor <matt(at)lindenelevator(dot)com>
To: Annita Veneti <annita(dot)veneti(at)qs-unisolution(dot)com>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5063: MS Access crashes by quiting after linking tables with PostgreSQL
Date: 2009-09-22 15:29:25
Message-ID: 4AB8ED55.9060100@lindenelevator.com (view raw or flat)
Thread:
Lists: pgsql-bugs
No.  You probably need someone more knowledgeable than myself!  Now that 
you have narrowed down the problem, someone should be able to help.

You will need to provide more details about your system.  i.e. operating 
system, PostgreSQL server version, driver version (I assume ODBC), and 
MS Access version...

Matt


Annita Veneti wrote:
> Matt you are absolutely right! The msysconf is not related...
> Yesterday I did some test and have seen that the access is working fine with postgres as long as the SSL mode is disable, as soon as I put it enabled then it crashes on shutdown....
> 
> Go figure!!!
> 
> Any ideas?
> 
> Annita
> 
> -----Ursprüngliche Nachricht-----
> Von: Matt Taylor [mailto:matt(at)lindenelevator(dot)com] 
> Gesendet: Montag, 21. September 2009 23:07
> An: Annita Veneti
> Cc: pgsql-bugs(at)postgresql(dot)org
> Betreff: Re: [BUGS] BUG #5063: MS Access crashes by quiting after linking tables with PostgreSQL
> 
> I think the msysconf error is not related to your issue:
> 
> http://archives.postgresql.org/pgadmin-support/2002-01/msg00035.php
> 
> Can you query data from the data source using MS Excel?
> 
> Matt
> 
> 
> Annita Veneti wrote:
>> Matt first thanks for the reply,
>>
>> I have check the log and it says 
>>
>>   Relation »msysconf« existiert nicht (that it doesn’t exist.
>>
>> I know that there is a setting in the pgAdmin to postgre create the table if it not there.
>> But I cannot find it , do you have any idea?
>>
>>
>> Annita 
>>
>>
>> -----Ursprüngliche Nachricht-----
>> Von: Matt Taylor [mailto:matt(at)lindenelevator(dot)com] 
>> Gesendet: Freitag, 18. September 2009 17:47
>> An: Annita Veneti
>> Cc: pgsql-bugs(at)postgresql(dot)org
>> Betreff: Re: [BUGS] BUG #5063: MS Access crashes by quiting after linking tables with PostgreSQL
>>
>> Have you tried turning on row versioning in the data source?
>>
>> Matt
>>
>>
>> Annita wrote:
>>> The following bug has been logged online:
>>>
>>> Bug reference:      5063
>>> Logged by:          Annita
>>> Email address:      annita(dot)veneti(at)qs-unisolution(dot)com
>>> PostgreSQL version: 8
>>> Operating system:   Windows
>>> Description:        MS Access  crashes by quiting after linking tables with
>>> PostgreSQL
>>> Details: 
>>>
>>> MS Access (2003,2007) crashes by closing down , after i have linked the
>>> tables of my postgreSQL database. I cannot find anything relevant with this
>>> problem. I have tried everything, the problem has to do with the
>>> postgredriver since this doesnt happen when i connect with MySql or SQL. 
>>>
>>> CAN ANYONE HELP??? please???
>>>
> 

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2009-09-22 15:47:39
Subject: Re: BUG #5072: User trying to drop an internally dependent object crashes server
Previous:From: Robert HaasDate: 2009-09-22 15:09:02
Subject: Re: BUG #5066: plperl issues with perl_destruct() and END blocks

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