Re: [ODBC] Issue with psqlodbc and MSACCESS - Mailing list pgsql-odbc

From Robert Ball
Subject Re: [ODBC] Issue with psqlodbc and MSACCESS
Date
Msg-id 803180ECCEC3D24284C2C2FD689B05C85B84F2@MAN4.free1.local
Whole thread Raw
In response to Re: [ODBC] Issue with psqlodbc and MSACCESS  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
List pgsql-odbc

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

 

pgsql-odbc by date:

Previous
From: "Inoue, Hiroshi"
Date:
Subject: Re: [ODBC] Issue with psqlodbc and MSACCESS
Next
From: hiroshi@winpg.jp (Hiroshi Saito)
Date:
Subject: [ODBC] psqlODBC 09.06.0310 Released