Обсуждение: [ODBC] Issue with psqlodbc and MSACCESS
Hello
I have done a test upgrade of psqlodbc to 9.6.300 running on Windows 10 and I now find my Microsoft access database which is using it crashes as soon as it tries to use the odbc connection.
The PostgreSQL database version is 9.4.11
I have enable the mylog driver option but do not get a mylog_????.log file created
I have pasted an error that is the event log related to the issue
Faulting application name: MSACCESS.EXE, version: 16.0.7668.2074, time stamp: 0x588def7a
Faulting module name: psqlodbc35w.dll, version: 9.6.3.0, time stamp: 0x590f2975
Exception code: 0xc0000005
Fault offset: 0x0004a253
Faulting process id: 0x1a78
Faulting application start time: 0x01d2c8bbf7aef197
Faulting application path: C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE
Faulting module path: C:\Program Files (x86)\psqlODBC\0906\bin\psqlodbc35w.dll
Report Id: 45eb07a6-34af-11e7-bb43-00219b1766b8
Faulting package full name:
Faulting package-relative application ID:
Not sure if this is a bug or a problem specific to me. I do not get this issue when using psqlodbc version 9.6.200
Robert Ball
Manifest
Tel: +44 (0)1376 504511 | Main: +44 (0)1376 503500 | Fax: +44 (0)1376 503550
Blog: https://blog.manifest.co.uk/ | Web: https://www.manifest.co.uk/
9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | England
----------------------------------------------------------------------------------------------------------------------------
Copyright: This e-mail may contain confidential or legally privileged information. If you are not the named addressee you must not use or disclose such information, instead please report it to admin@manifest.co.uk.
Legal: Manifest is the trading name of: Manifest Information Services Ltd: Registered in England Number 3401145 & The Manifest Voting Agency Ltd: Registered in England Number 2920820 Registered Office at above address. Please Click Here https://www.manifest.co.uk/legal/ for further information.
Hello
I have done a test upgrade of psqlodbc to 9.6.300 running on Windows 10 and I now find my Microsoft access database which is using it crashes as soon as it tries to use the odbc connection.
The PostgreSQL database version is 9.4.11
I have enable the mylog driver option but do not get a mylog_????.log file created
Did you enable Datasource or Global option?
Couldn't you find mylog_xxxx.log in C:\Users\your_usernamr\ folder?
regards,
Hiroshi Inoue
I have pasted an error that is the event log related to the issue
Faulting application name: MSACCESS.EXE, version: 16.0.7668.2074, time stamp: 0x588def7a
Faulting module name: psqlodbc35w.dll, version: 9.6.3.0, time stamp: 0x590f2975
Exception code: 0xc0000005
Fault offset: 0x0004a253
Faulting process id: 0x1a78
Faulting application start time: 0x01d2c8bbf7aef197
Faulting application path: C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE
Faulting module path: C:\Program Files (x86)\psqlODBC\0906\bin\psqlodbc35w.dll
Report Id: 45eb07a6-34af-11e7-bb43-00219b1766b8
Faulting package full name:
Faulting package-relative application ID:
Not sure if this is a bug or a problem specific to me. I do not get this issue when using psqlodbc version 9.6.200
Robert Ball
Maybe I found the cause.
Could you try the test drivers 9.6.0301 at
http://www.ne.jp/asahi/inocchi
?
regards,
Hiroshi Inoue
Hi Robert,On 2017/05/09 21:22, Robert Ball wrote:Hello
I have done a test upgrade of psqlodbc to 9.6.300 running on Windows 10 and I now find my Microsoft access database which is using it crashes as soon as it tries to use the odbc connection.
The PostgreSQL database version is 9.4.11
I have enable the mylog driver option but do not get a mylog_????.log file created
Did you enable Datasource or Global option?
Couldn't you find mylog_xxxx.log in C:\Users\your_usernamr\ folder?
regards,
Hiroshi Inoue
I have pasted an error that is the event log related to the issue
Faulting application name: MSACCESS.EXE, version: 16.0.7668.2074, time stamp: 0x588def7a
Faulting module name: psqlodbc35w.dll, version: 9.6.3.0, time stamp: 0x590f2975
Exception code: 0xc0000005
Fault offset: 0x0004a253
Faulting process id: 0x1a78
Faulting application start time: 0x01d2c8bbf7aef197
Faulting application path: C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE
Faulting module path: C:\Program Files (x86)\psqlODBC\0906\bin\psqlodbc35w.dll
Report Id: 45eb07a6-34af-11e7-bb43-00219b1766b8
Faulting package full name:
Faulting package-relative application ID:
Not sure if this is a bug or a problem specific to me. I do not get this issue when using psqlodbc version 9.6.200
Robert Ball
Hello Hiroshi
Many thanks that has fixed the issue.
Apologies as well, I found the mylog_????.log and psqlodbc_????.log files in the directory I had specified in the global settings, I had been looking in c:\ .
Robert Ball
Manifest
Tel: +44 (0)1376 504511 | Main: +44 (0)1376 503500 | Fax: +44 (0)1376 503550
Blog: https://blog.manifest.co.uk/ | Web: https://www.manifest.co.uk/
9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | England
----------------------------------------------------------------------------------------------------------------------------
Copyright: This e-mail may contain confidential or legally privileged information. If you are not the named addressee you must not use or disclose such information, instead please report it to admin@manifest.co.uk.
Legal: Manifest is the trading name of: Manifest Information Services Ltd: Registered in England Number 3401145 & The Manifest Voting Agency Ltd: Registered in England Number 2920820 Registered Office at above address. Please Click Here https://www.manifest.co.uk/legal/ for further information.
From: Inoue, Hiroshi [mailto:h-inoue@dream.email.ne.jp]
Sent: 10 May 2017 03:57
To: Robert Ball <Robert.Ball@manifest.co.uk>
Cc: 'pgsql-odbc@postgresql.org' <pgsql-odbc@postgresql.org>
Subject: Re: [ODBC] Issue with psqlodbc and MSACCESS
Hi Robert,
Maybe I found the cause.
Could you try the test drivers 9.6.0301 at
http://www.ne.jp/asahi/inocchichichi/entrance/psqlodbc/
?
regards,
Hiroshi Inoue
On 2017/05/10 8:11, Inoue, Hiroshi wrote:
Hi Robert,
On 2017/05/09 21:22, Robert Ball wrote:
Hello
I have done a test upgrade of psqlodbc to 9.6.300 running on Windows 10 and I now find my Microsoft access database which is using it crashes as soon as it tries to use the odbc connection.
The PostgreSQL database version is 9.4.11
I have enable the mylog driver option but do not get a mylog_????.log file created
Did you enable Datasource or Global option?
Couldn't you find mylog_xxxx.log in C:\Users\your_usernamr\ folder?
regards,
Hiroshi Inoue
I have pasted an error that is the event log related to the issue
Faulting application name: MSACCESS.EXE, version: 16.0.7668.2074, time stamp: 0x588def7a
Faulting module name: psqlodbc35w.dll, version: 9.6.3.0, time stamp: 0x590f2975
Exception code: 0xc0000005
Fault offset: 0x0004a253
Faulting process id: 0x1a78
Faulting application start time: 0x01d2c8bbf7aef197
Faulting application path: C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE
Faulting module path: C:\Program Files (x86)\psqlODBC\0906\bin\psqlodbc35w.dll
Report Id: 45eb07a6-34af-11e7-bb43-00219b1766b8
Faulting package full name:
Faulting package-relative application ID:
Not sure if this is a bug or a problem specific to me. I do not get this issue when using psqlodbc version 9.6.200
Robert Ball