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

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???

On Fri, Sep 18, 2009 at 5:45 AM, Annita
<annita(dot)veneti(at)qs-unisolution(dot)com> 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???

I think you probably need to provide a lot more detail about what you
are doing for anyone to have a chance of helping you with it.

...Robert

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???
>

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???
>

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???
>>
>

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???
>>
>

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???
>>>
>

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?
>
What version of the PostgreSQL client libraries are you running. There
is a bug in anything before 8.4 that would unlink libpq from memory and
not remove the SSL callback functions in that code. When other
libraries attempt to shutdown their SSL, it crashes as those functions
point to invalid memory. I've not seen this on the Windows platform
personally yet. But I have seen it running php on linux. Have a look
at " libpq does not manage SSL callbacks properly when other libraries
are involved." reported by me on 25/6/08.

Regards

Russell

You are right.
This is solved in 8.4 and is in the release notes. Even thought the 8.4 has a bug in displaying the SSL mode and that’s why I didn’t installed at the first place, then I realized is only a display problem and if you write in the registry directly everything is ok.

I have posted another bug issue for this.

So my problem is pertly solved, and thanks a million guys for all the help:)

Annita Veneti

-----Ursprüngliche Nachricht-----
Von: Russell Smith [mailto:mr-russ(at)pws(dot)com(dot)au]
Gesendet: Donnerstag, 24. September 2009 23:55
An: Annita Veneti
Cc: Matt Taylor; pgsql-bugs(at)postgresql(dot)org
Betreff: Re: [BUGS] BUG #5063: MS Access crashes by quiting after linking tables with PostgreSQL

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?
>
What version of the PostgreSQL client libraries are you running. There
is a bug in anything before 8.4 that would unlink libpq from memory and
not remove the SSL callback functions in that code. When other
libraries attempt to shutdown their SSL, it crashes as those functions
point to invalid memory. I've not seen this on the Windows platform
personally yet. But I have seen it running php on linux. Have a look
at " libpq does not manage SSL callbacks properly when other libraries
are involved." reported by me on 25/6/08.

Regards

Russell