Lists: | pgsql-bugs |
---|
From: | "Annita" <annita(dot)veneti(at)qs-unisolution(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5063: MS Access crashes by quiting after linking tables with PostgreSQL |
Date: | 2009-09-18 09:45:52 |
Message-ID: | 200909180945.n8I9jqgu052293@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
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???
From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Annita <annita(dot)veneti(at)qs-unisolution(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5063: MS Access crashes by quiting after linking tables with PostgreSQL |
Date: | 2009-09-18 13:37:21 |
Message-ID: | 603c8f070909180637j43b8f498l287d516e2a2ef2c3@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
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
From: | Matt Taylor <matt(at)lindenelevator(dot)com> |
---|---|
To: | Annita <annita(dot)veneti(at)qs-unisolution(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5063: MS Access crashes by quiting after linking tables with PostgreSQL |
Date: | 2009-09-18 15:46:56 |
Message-ID: | 4AB3AB70.8000002@lindenelevator.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
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???
>
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-21 07:43:37 |
Message-ID: | 5B57754F59D515429A73E49A76C04C95C852400549@PEMEXMBXVS01.jellyfishnet.co.uk.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
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???
>
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-21 21:07:11 |
Message-ID: | 4AB7EAFF.1030801@lindenelevator.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
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???
>>
>
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 |
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???
>>
>
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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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???
>>>
>
From: | Russell Smith <mr-russ(at)pws(dot)com(dot)au> |
---|---|
To: | Annita Veneti <annita(dot)veneti(at)qs-unisolution(dot)com> |
Cc: | Matt Taylor <matt(at)lindenelevator(dot)com>, "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-24 21:54:36 |
Message-ID: | 4ABBEA9C.5000103@pws.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
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
From: | Annita Veneti <annita(dot)veneti(at)qs-unisolution(dot)com> |
---|---|
To: | Russell Smith <mr-russ(at)pws(dot)com(dot)au> |
Cc: | Matt Taylor <matt(at)lindenelevator(dot)com>, "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-25 07:56:22 |
Message-ID: | 5B57754F59D515429A73E49A76C04C95C85266A103@PEMEXMBXVS01.jellyfishnet.co.uk.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
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