Re: Issue with psqlodbc and MSACCESS

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(at)manifest(dot)co(dot)uk<mailto:admin(at)manifest(dot)co(dot)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(at)dream(dot)email(dot)ne(dot)jp]
Sent: 10 May 2017 03:57
To: Robert Ball <Robert(dot)Ball(at)manifest(dot)co(dot)uk>
Cc: 'pgsql-odbc(at)postgresql(dot)org' <pgsql-odbc(at)postgresql(dot)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