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

From: Annita Veneti <annita(dot)veneti(at)qs-unisolution(dot)com>
To: Matt Taylor <matt(at)lindenelevator(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 08:30:29
Message-ID: 5B57754F59D515429A73E49A76C04C95C8524FBA48@PEMEXMBXVS01.jellyfishnet.co.uk.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tim Bunce 2009-09-22 08:39:00 Re: BUG #5066: plperl issues with perl_destruct() and END blocks
Previous Message Bhushan Verma 2009-09-22 05:54:04 Re: Databse installation problem