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.veneti@qs-unisolution.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.veneti@qs-unisolution.com> wrote:
The following bug has been logged online:
Bug reference: 5063
Logged by: Annita
Email address: annita.veneti@qs-unisolution.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:
Show quoted text
The following bug has been logged online:
Bug reference: 5063
Logged by: Annita
Email address: annita.veneti@qs-unisolution.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@lindenelevator.com]
Gesendet: Freitag, 18. September 2009 17:47
An: Annita Veneti
Cc: pgsql-bugs@postgresql.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:
Show quoted text
The following bug has been logged online:
Bug reference: 5063
Logged by: Annita
Email address: annita.veneti@qs-unisolution.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:
Show quoted text
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@lindenelevator.com]
Gesendet: Freitag, 18. September 2009 17:47
An: Annita Veneti
Cc: pgsql-bugs@postgresql.org
Betreff: Re: [BUGS] BUG #5063: MS Access crashes by quiting after linking tables with PostgreSQLHave 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.veneti@qs-unisolution.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@lindenelevator.com]
Gesendet: Montag, 21. September 2009 23:07
An: Annita Veneti
Cc: pgsql-bugs@postgresql.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:
Show quoted text
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@lindenelevator.com]
Gesendet: Freitag, 18. September 2009 17:47
An: Annita Veneti
Cc: pgsql-bugs@postgresql.org
Betreff: Re: [BUGS] BUG #5063: MS Access crashes by quiting after linking tables with PostgreSQLHave 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.veneti@qs-unisolution.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:
Show quoted text
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@lindenelevator.com]
Gesendet: Montag, 21. September 2009 23:07
An: Annita Veneti
Cc: pgsql-bugs@postgresql.org
Betreff: Re: [BUGS] BUG #5063: MS Access crashes by quiting after linking tables with PostgreSQLI 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@lindenelevator.com]
Gesendet: Freitag, 18. September 2009 17:47
An: Annita Veneti
Cc: pgsql-bugs@postgresql.org
Betreff: Re: [BUGS] BUG #5063: MS Access crashes by quiting after linking tables with PostgreSQLHave 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.veneti@qs-unisolution.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@pws.com.au]
Gesendet: Donnerstag, 24. September 2009 23:55
An: Annita Veneti
Cc: Matt Taylor; pgsql-bugs@postgresql.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