Thread: 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: =A0 =A0 =A05063
> Logged by: =A0 =A0 =A0 =A0 =A0Annita
> Email address: =A0 =A0 =A0annita.veneti@qs-unisolution.com
> PostgreSQL version: 8
> Operating system: =A0 Windows
> Description: =A0 =A0 =A0 =A0MS Access =A0crashes 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 th=
is
> 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.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???
>

TWF0dCBmaXJzdCB0aGFua3MgZm9yIHRoZSByZXBseSwNCg0KSSBoYXZlIGNo
ZWNrIHRoZSBsb2cgYW5kIGl0IHNheXMgDQoNCiAgUmVsYXRpb24gwrttc3lz
Y29uZsKrIGV4aXN0aWVydCBuaWNodCAodGhhdCBpdCBkb2VzbuKAmXQgZXhp
c3QuDQoNCkkga25vdyB0aGF0IHRoZXJlIGlzIGEgc2V0dGluZyBpbiB0aGUg
cGdBZG1pbiB0byBwb3N0Z3JlIGNyZWF0ZSB0aGUgdGFibGUgaWYgaXQgbm90
IHRoZXJlLg0KQnV0IEkgY2Fubm90IGZpbmQgaXQgLCBkbyB5b3UgaGF2ZSBh
bnkgaWRlYT8NCg0KDQpBbm5pdGEgDQoNCg0KLS0tLS1VcnNwcsO8bmdsaWNo
ZSBOYWNocmljaHQtLS0tLQ0KVm9uOiBNYXR0IFRheWxvciBbbWFpbHRvOm1h
dHRAbGluZGVuZWxldmF0b3IuY29tXSANCkdlc2VuZGV0OiBGcmVpdGFnLCAx
OC4gU2VwdGVtYmVyIDIwMDkgMTc6NDcNCkFuOiBBbm5pdGEgVmVuZXRpDQpD
YzogcGdzcWwtYnVnc0Bwb3N0Z3Jlc3FsLm9yZw0KQmV0cmVmZjogUmU6IFtC
VUdTXSBCVUcgIzUwNjM6IE1TIEFjY2VzcyBjcmFzaGVzIGJ5IHF1aXRpbmcg
YWZ0ZXIgbGlua2luZyB0YWJsZXMgd2l0aCBQb3N0Z3JlU1FMDQoNCkhhdmUg
eW91IHRyaWVkIHR1cm5pbmcgb24gcm93IHZlcnNpb25pbmcgaW4gdGhlIGRh
dGEgc291cmNlPw0KDQpNYXR0DQoNCg0KQW5uaXRhIHdyb3RlOg0KPiBUaGUg
Zm9sbG93aW5nIGJ1ZyBoYXMgYmVlbiBsb2dnZWQgb25saW5lOg0KPiANCj4g
QnVnIHJlZmVyZW5jZTogICAgICA1MDYzDQo+IExvZ2dlZCBieTogICAgICAg
ICAgQW5uaXRhDQo+IEVtYWlsIGFkZHJlc3M6ICAgICAgYW5uaXRhLnZlbmV0
aUBxcy11bmlzb2x1dGlvbi5jb20NCj4gUG9zdGdyZVNRTCB2ZXJzaW9uOiA4
DQo+IE9wZXJhdGluZyBzeXN0ZW06ICAgV2luZG93cw0KPiBEZXNjcmlwdGlv
bjogICAgICAgIE1TIEFjY2VzcyAgY3Jhc2hlcyBieSBxdWl0aW5nIGFmdGVy
IGxpbmtpbmcgdGFibGVzIHdpdGgNCj4gUG9zdGdyZVNRTA0KPiBEZXRhaWxz
OiANCj4gDQo+IE1TIEFjY2VzcyAoMjAwMywyMDA3KSBjcmFzaGVzIGJ5IGNs
b3NpbmcgZG93biAsIGFmdGVyIGkgaGF2ZSBsaW5rZWQgdGhlDQo+IHRhYmxl
cyBvZiBteSBwb3N0Z3JlU1FMIGRhdGFiYXNlLiBJIGNhbm5vdCBmaW5kIGFu
eXRoaW5nIHJlbGV2YW50IHdpdGggdGhpcw0KPiBwcm9ibGVtLiBJIGhhdmUg
dHJpZWQgZXZlcnl0aGluZywgdGhlIHByb2JsZW0gaGFzIHRvIGRvIHdpdGgg
dGhlDQo+IHBvc3RncmVkcml2ZXIgc2luY2UgdGhpcyBkb2VzbnQgaGFwcGVu
IHdoZW4gaSBjb25uZWN0IHdpdGggTXlTcWwgb3IgU1FMLiANCj4gDQo+IENB
TiBBTllPTkUgSEVMUD8/PyBwbGVhc2U/Pz8NCj4gDQo=

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

TWF0dCB5b3UgYXJlIGFic29sdXRlbHkgcmlnaHQhIFRoZSBtc3lzY29uZiBp
cyBub3QgcmVsYXRlZC4uLg0KWWVzdGVyZGF5IEkgZGlkIHNvbWUgdGVzdCBh
bmQgaGF2ZSBzZWVuIHRoYXQgdGhlIGFjY2VzcyBpcyB3b3JraW5nIGZpbmUg
d2l0aCBwb3N0Z3JlcyBhcyBsb25nIGFzIHRoZSBTU0wgbW9kZSBpcyBkaXNh
YmxlLCBhcyBzb29uIGFzIEkgcHV0IGl0IGVuYWJsZWQgdGhlbiBpdCBjcmFz
aGVzIG9uIHNodXRkb3duLi4uLg0KDQpHbyBmaWd1cmUhISENCg0KQW55IGlk
ZWFzPw0KDQpBbm5pdGENCg0KLS0tLS1VcnNwcsO8bmdsaWNoZSBOYWNocmlj
aHQtLS0tLQ0KVm9uOiBNYXR0IFRheWxvciBbbWFpbHRvOm1hdHRAbGluZGVu
ZWxldmF0b3IuY29tXSANCkdlc2VuZGV0OiBNb250YWcsIDIxLiBTZXB0ZW1i
ZXIgMjAwOSAyMzowNw0KQW46IEFubml0YSBWZW5ldGkNCkNjOiBwZ3NxbC1i
dWdzQHBvc3RncmVzcWwub3JnDQpCZXRyZWZmOiBSZTogW0JVR1NdIEJVRyAj
NTA2MzogTVMgQWNjZXNzIGNyYXNoZXMgYnkgcXVpdGluZyBhZnRlciBsaW5r
aW5nIHRhYmxlcyB3aXRoIFBvc3RncmVTUUwNCg0KSSB0aGluayB0aGUgbXN5
c2NvbmYgZXJyb3IgaXMgbm90IHJlbGF0ZWQgdG8geW91ciBpc3N1ZToNCg0K
aHR0cDovL2FyY2hpdmVzLnBvc3RncmVzcWwub3JnL3BnYWRtaW4tc3VwcG9y
dC8yMDAyLTAxL21zZzAwMDM1LnBocA0KDQpDYW4geW91IHF1ZXJ5IGRhdGEg
ZnJvbSB0aGUgZGF0YSBzb3VyY2UgdXNpbmcgTVMgRXhjZWw/DQoNCk1hdHQN
Cg0KDQpBbm5pdGEgVmVuZXRpIHdyb3RlOg0KPiBNYXR0IGZpcnN0IHRoYW5r
cyBmb3IgdGhlIHJlcGx5LA0KPiANCj4gSSBoYXZlIGNoZWNrIHRoZSBsb2cg
YW5kIGl0IHNheXMgDQo+IA0KPiAgIFJlbGF0aW9uIMK7bXN5c2NvbmbCqyBl
eGlzdGllcnQgbmljaHQgKHRoYXQgaXQgZG9lc27igJl0IGV4aXN0Lg0KPiAN
Cj4gSSBrbm93IHRoYXQgdGhlcmUgaXMgYSBzZXR0aW5nIGluIHRoZSBwZ0Fk
bWluIHRvIHBvc3RncmUgY3JlYXRlIHRoZSB0YWJsZSBpZiBpdCBub3QgdGhl
cmUuDQo+IEJ1dCBJIGNhbm5vdCBmaW5kIGl0ICwgZG8geW91IGhhdmUgYW55
IGlkZWE/DQo+IA0KPiANCj4gQW5uaXRhIA0KPiANCj4gDQo+IC0tLS0tVXJz
cHLDvG5nbGljaGUgTmFjaHJpY2h0LS0tLS0NCj4gVm9uOiBNYXR0IFRheWxv
ciBbbWFpbHRvOm1hdHRAbGluZGVuZWxldmF0b3IuY29tXSANCj4gR2VzZW5k
ZXQ6IEZyZWl0YWcsIDE4LiBTZXB0ZW1iZXIgMjAwOSAxNzo0Nw0KPiBBbjog
QW5uaXRhIFZlbmV0aQ0KPiBDYzogcGdzcWwtYnVnc0Bwb3N0Z3Jlc3FsLm9y
Zw0KPiBCZXRyZWZmOiBSZTogW0JVR1NdIEJVRyAjNTA2MzogTVMgQWNjZXNz
IGNyYXNoZXMgYnkgcXVpdGluZyBhZnRlciBsaW5raW5nIHRhYmxlcyB3aXRo
IFBvc3RncmVTUUwNCj4gDQo+IEhhdmUgeW91IHRyaWVkIHR1cm5pbmcgb24g
cm93IHZlcnNpb25pbmcgaW4gdGhlIGRhdGEgc291cmNlPw0KPiANCj4gTWF0
dA0KPiANCj4gDQo+IEFubml0YSB3cm90ZToNCj4+IFRoZSBmb2xsb3dpbmcg
YnVnIGhhcyBiZWVuIGxvZ2dlZCBvbmxpbmU6DQo+Pg0KPj4gQnVnIHJlZmVy
ZW5jZTogICAgICA1MDYzDQo+PiBMb2dnZWQgYnk6ICAgICAgICAgIEFubml0
YQ0KPj4gRW1haWwgYWRkcmVzczogICAgICBhbm5pdGEudmVuZXRpQHFzLXVu
aXNvbHV0aW9uLmNvbQ0KPj4gUG9zdGdyZVNRTCB2ZXJzaW9uOiA4DQo+PiBP
cGVyYXRpbmcgc3lzdGVtOiAgIFdpbmRvd3MNCj4+IERlc2NyaXB0aW9uOiAg
ICAgICAgTVMgQWNjZXNzICBjcmFzaGVzIGJ5IHF1aXRpbmcgYWZ0ZXIgbGlu
a2luZyB0YWJsZXMgd2l0aA0KPj4gUG9zdGdyZVNRTA0KPj4gRGV0YWlsczog
DQo+Pg0KPj4gTVMgQWNjZXNzICgyMDAzLDIwMDcpIGNyYXNoZXMgYnkgY2xv
c2luZyBkb3duICwgYWZ0ZXIgaSBoYXZlIGxpbmtlZCB0aGUNCj4+IHRhYmxl
cyBvZiBteSBwb3N0Z3JlU1FMIGRhdGFiYXNlLiBJIGNhbm5vdCBmaW5kIGFu
eXRoaW5nIHJlbGV2YW50IHdpdGggdGhpcw0KPj4gcHJvYmxlbS4gSSBoYXZl
IHRyaWVkIGV2ZXJ5dGhpbmcsIHRoZSBwcm9ibGVtIGhhcyB0byBkbyB3aXRo
IHRoZQ0KPj4gcG9zdGdyZWRyaXZlciBzaW5jZSB0aGlzIGRvZXNudCBoYXBw
ZW4gd2hlbiBpIGNvbm5lY3Qgd2l0aCBNeVNxbCBvciBTUUwuIA0KPj4NCj4+
IENBTiBBTllPTkUgSEVMUD8/PyBwbGVhc2U/Pz8NCj4+DQo+IA0K

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@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:
>> 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:
>>> 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

WW91IGFyZSByaWdodC4NClRoaXMgaXMgc29sdmVkIGluIDguNCBhbmQgaXMg
aW4gdGhlIHJlbGVhc2Ugbm90ZXMuIEV2ZW4gdGhvdWdodCB0aGUgOC40IGhh
cyBhIGJ1ZyBpbiBkaXNwbGF5aW5nIHRoZSBTU0wgbW9kZSBhbmQgdGhhdOKA
mXMgd2h5IEkgZGlkbuKAmXQgaW5zdGFsbGVkIGF0IHRoZSBmaXJzdCBwbGFj
ZSwgdGhlbiBJIHJlYWxpemVkIGlzIG9ubHkgYSBkaXNwbGF5IHByb2JsZW0g
YW5kIGlmIHlvdSB3cml0ZSBpbiB0aGUgcmVnaXN0cnkgZGlyZWN0bHkgZXZl
cnl0aGluZyBpcyBvay4NCg0KSSBoYXZlIHBvc3RlZCBhbm90aGVyIGJ1ZyBp
c3N1ZSBmb3IgdGhpcy4NCg0KDQpTbyBteSBwcm9ibGVtIGlzIHBlcnRseSBz
b2x2ZWQsIGFuZCB0aGFua3MgYSBtaWxsaW9uIGd1eXMgZm9yIGFsbCB0aGUg
aGVscDopDQoNCkFubml0YSBWZW5ldGkgDQoNCi0tLS0tVXJzcHLDvG5nbGlj
aGUgTmFjaHJpY2h0LS0tLS0NClZvbjogUnVzc2VsbCBTbWl0aCBbbWFpbHRv
Om1yLXJ1c3NAcHdzLmNvbS5hdV0gDQpHZXNlbmRldDogRG9ubmVyc3RhZywg
MjQuIFNlcHRlbWJlciAyMDA5IDIzOjU1DQpBbjogQW5uaXRhIFZlbmV0aQ0K
Q2M6IE1hdHQgVGF5bG9yOyBwZ3NxbC1idWdzQHBvc3RncmVzcWwub3JnDQpC
ZXRyZWZmOiBSZTogW0JVR1NdIEJVRyAjNTA2MzogTVMgQWNjZXNzIGNyYXNo
ZXMgYnkgcXVpdGluZyBhZnRlciBsaW5raW5nIHRhYmxlcyB3aXRoIFBvc3Rn
cmVTUUwNCg0KQW5uaXRhIFZlbmV0aSB3cm90ZToNCj4gTWF0dCB5b3UgYXJl
IGFic29sdXRlbHkgcmlnaHQhIFRoZSBtc3lzY29uZiBpcyBub3QgcmVsYXRl
ZC4uLg0KPiBZZXN0ZXJkYXkgSSBkaWQgc29tZSB0ZXN0IGFuZCBoYXZlIHNl
ZW4gdGhhdCB0aGUgYWNjZXNzIGlzIHdvcmtpbmcgZmluZSB3aXRoIHBvc3Rn
cmVzIGFzIGxvbmcgYXMgdGhlIFNTTCBtb2RlIGlzIGRpc2FibGUsIGFzIHNv
b24gYXMgSSBwdXQgaXQgZW5hYmxlZCB0aGVuIGl0IGNyYXNoZXMgb24gc2h1
dGRvd24uLi4uDQo+DQo+IEdvIGZpZ3VyZSEhIQ0KPg0KPiBBbnkgaWRlYXM/
DQo+ICAgDQpXaGF0IHZlcnNpb24gb2YgdGhlIFBvc3RncmVTUUwgY2xpZW50
IGxpYnJhcmllcyBhcmUgeW91IHJ1bm5pbmcuICBUaGVyZQ0KaXMgYSBidWcg
aW4gYW55dGhpbmcgYmVmb3JlIDguNCB0aGF0IHdvdWxkIHVubGluayBsaWJw
cSBmcm9tIG1lbW9yeSBhbmQNCm5vdCByZW1vdmUgdGhlIFNTTCBjYWxsYmFj
ayBmdW5jdGlvbnMgaW4gdGhhdCBjb2RlLiAgV2hlbiBvdGhlcg0KbGlicmFy
aWVzIGF0dGVtcHQgdG8gc2h1dGRvd24gdGhlaXIgU1NMLCBpdCBjcmFzaGVz
IGFzIHRob3NlIGZ1bmN0aW9ucw0KcG9pbnQgdG8gaW52YWxpZCBtZW1vcnku
ICBJJ3ZlIG5vdCBzZWVuIHRoaXMgb24gdGhlIFdpbmRvd3MgcGxhdGZvcm0N
CnBlcnNvbmFsbHkgeWV0LiAgQnV0IEkgaGF2ZSBzZWVuIGl0IHJ1bm5pbmcg
cGhwIG9uIGxpbnV4LiAgSGF2ZSBhIGxvb2sNCmF0ICIgbGlicHEgZG9lcyBu
b3QgbWFuYWdlIFNTTCBjYWxsYmFja3MgcHJvcGVybHkgd2hlbiBvdGhlciBs
aWJyYXJpZXMNCmFyZSBpbnZvbHZlZC4iIHJlcG9ydGVkIGJ5IG1lIG9uIDI1
LzYvMDguDQoNClJlZ2FyZHMNCg0KUnVzc2VsbA0K