From: "Wal, Jan Tjalling  van der" <jan_tjalling.vanderwal@wur.nl>
To: "pgsql-odbc@postgresql.org" <pgsql-odbc@postgresql.org>
Subject: psqlODBC x64 not respecting read-only parameter?
Thread-Topic: psqlODBC x64 not respecting read-only parameter?
Thread-Index: AdgiTJLaAh7nCMY8S4eq9T6A5vL03Q==
Date: Tue, 15 Feb 2022 09:31:13 +0000
Message-ID: 
 <AM0PR01MB5634A0243CABD76C4F35000EDD349@AM0PR01MB5634.eurprd01.prod.exchangelabs.com>
Accept-Language: en-NL, en-US
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?ogaLDLgRYVKSLmPPjoz6nBnHPev5NSTcFlhinsJrZGK7UKq0H5tWjzM0DJjA?=
 =?us-ascii?Q?lQXASkLGFLIkVDvQ9eNrfVLnwofiBDcuNgTee4uf1E70ykrwua7JCvlXIPol?=
 =?us-ascii?Q?e+xLtk3JqoEWOLv/su+kUpCfe7SxtAe1m3OdXk2hNlZx2vdMMtGAc4JIbTY6?=
 =?us-ascii?Q?ZfFp1qxEcQ64xsu7YoDGcgbPkCBAPkgLT6GSqOK2JFJQy4M4L7Zu72f9MH5K?=
 =?us-ascii?Q?4NGdI+5FlrW6QcEFbcHNW7SKE8siGJbsh3DcBkZH1hEoFh3rSqr16zcQ0nKU?=
 =?us-ascii?Q?xG9KmIrvkR1hGr/3eKSMMJU11Fd2p2XD/8W4Oer6VOIe6wB90Kf4eEU4Prnp?=
 =?us-ascii?Q?bnPPYdYk+Y3wfOczojEStwVfehBppyqij6qb6enZv8OvC9xq/KgajyormX1C?=
 =?us-ascii?Q?xDCYcjmKc6tGS7QmuuFA7+k0uHqaOZjFlwLuGwd4WLPtNeJtHvAH2XgZ2n5k?=
 =?us-ascii?Q?XBk6SRr//+maNq040J2x/hPZlVcX8I8a9dY2GMQRn7+58Mq5jESdnIc49Vd7?=
 =?us-ascii?Q?YimoZPAeoNPn4QPmmN9fwQ+R78bY0RdtIGc4TUGxuJzU9MqcXwSZDEM6NxPD?=
 =?us-ascii?Q?lBgq4cPengEUzcyffy608NyOjSSxte7CHev5aOlIFo66GCK9Du/BvxgImxt3?=
 =?us-ascii?Q?nZs/VuU3hqNKtju3GdDI4Mgq46nNs6S5RsBXPeLlvQHGvVJM1WV8C1p8GRmv?=
 =?us-ascii?Q?RWzbhXiv9E6O5efQrKBvChvIYN7duTlPtnGht4Fjm+O94OLGkZ6zY+7UlIuo?=
 =?us-ascii?Q?zQ+Ommj5dPSWS3ax03omulcmE7lBFQvcsyGW7n0GKmfiwHVaxhspZLIKHCQI?=
 =?us-ascii?Q?VLyuLVLyoPHkLue6T5yGTYKN1YoMbjqeLwuFu3i2yznme3YZKtS3rocM9Kpt?=
 =?us-ascii?Q?qkQ0IejZVyGJM7aj3anohZ+405NtZgcfGKnv+lSCc0kpdds3ex/fYNYVEjlg?=
 =?us-ascii?Q?mxsU5Hf6ciiZzXm8MDrWvXqBi5qHTL4CrgKZAPHyTmQZ/yIJWzn3EHjgRj/A?=
 =?us-ascii?Q?EjxWZjA/izWWn4i0VIVRPHuy/wGjWdV9kBTVAzqDipIUqcQa9Q9Bv+5ULpAT?=
 =?us-ascii?Q?6A0mb/zyaI9xjN5o7YjcDRSXyQF8UdAj1JQwOyRQuhdccZVnHD74etlwDizM?=
 =?us-ascii?Q?Fq2QD/Sg/hdF4+NOPUC9cgZ3g1/c6X/NXCL9BQu3MSuS9hS/lMUsnNMq04Xc?=
 =?us-ascii?Q?eSpVkEQzmwHh2zrBrCxdoNb3NuccMYG9FtJhp0gYPOoB0qyNYo6glfVcJIp5?=
 =?us-ascii?Q?g+fL+Pp5BhNXq2LTq9aHFWsZbokdFLpm8QJsyTTWjsYeOA8F/aZ8zAMjOQAM?=
 =?us-ascii?Q?VmD8Bs+wlyZRiiGvIviyKRaHv2LxMFZivu//uTbA8xUWXeIZjBZO5t2bOiZ7?=
 =?us-ascii?Q?cn6co7tA3c8C3VRd5Dl1uhd+9e8d0T+6hRkalA8Hk+V15mAPUztXXEoqaEAW?=
 =?us-ascii?Q?MCIAKXnjenNQ6WOTkzPzV99aCfMmzBUpfX+owfxFGqzcC9AGMWfzjCAMcIId?=
 =?us-ascii?Q?3B4GDRRFQ3D+qrglhrRCcyFtePlwPz7HQl78jCSB1niIMoyaJmw0tg21YpxQ?=
 =?us-ascii?Q?5m8gLHG6PDvwhGwYhgzIKhR4f57YLIzX6IhOUcAUVaZvqyM4rQh+hK6kQ//3?=
 =?us-ascii?Q?n6Z2xHi8vs3JtRqKSUx7qc8rljgXSbFiS8NFVF4o99Dxd9aI0cji+5qf/aHt?=
 =?us-ascii?Q?fHVSeA=3D=3D?=
Content-Type: multipart/related;
	boundary="_004_AM0PR01MB5634A0243CABD76C4F35000EDD349AM0PR01MB5634eurp_";
	type="multipart/alternative"
MIME-Version: 1.0
X-OriginatorOrg: wur.nl
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: 
 AM0PR01MB5634.eurprd01.prod.exchangelabs.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 9a237b72-b2ea-44f1-d8fe-08d9f065e876
X-MS-Exchange-CrossTenant-originalarrivaltime: 15 Feb 2022 09:31:13.1164
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 27d137e5-761f-4dc1-af88-d26430abb18f
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 /WLKMX+BgLW5QfKsRSGw9AWuWqECpjuPojsZcqRB0DCNpBPfPyWGji4IjPc4lx0KokzLcvC+4qdSH0Pb3pXxU1Wbtmg57zY9iS6lXqaoyFU=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: AM0PR0102MB3234
List-Id: <pgsql-odbc.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-odbc@lists.postgresql.org>
List-Owner: <mailto:pgsql-odbc-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-odbc>
Archived-At: 
 <https://www.postgresql.org/message-id/AM0PR01MB5634A0243CABD76C4F35000EDD349%40AM0PR01MB5634.eurprd01.prod.exchangelabs.com>
Precedence: bulk

--_004_AM0PR01MB5634A0243CABD76C4F35000EDD349AM0PR01MB5634eurp_
Content-Type: multipart/alternative;
	boundary="_000_AM0PR01MB5634A0243CABD76C4F35000EDD349AM0PR01MB5634eurp_"

--_000_AM0PR01MB5634A0243CABD76C4F35000EDD349AM0PR01MB5634eurp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Dear psqlODBC-peoples,

I have been trying to get an MS-Access front-end to connect with a PostgreS=
QL-backend and although much of what I want is working by now, there is a p=
otential glitch regarding the read-only parameter.

Working with these versions:
Microsoft(r) Access(r) for Microsoft 365 MSO (Version 2112 Build 16.0.14729=
.20254) 64-bit
psqlodbc_13_02_0000 is the installed driver (also 64 bit).

My connection string looks like this:
ODBC;Driver=3D{PostgreSQL Unicode(x64)};DATABASE=3D<dbname>;SERVER=3D<srvrn=
ame>;PORT=3D5432;UID=3D<user>;PWD=3D<password>;A0=3D0;CA=3Dp;A7=3D100;B0=3D=
255;B1=3D8190;BI=3D0;C2=3Ddd_;D6=3D-101;CX=3D1c205008b;A1=3D7.4-1;D1=3D240;=
D2=3D80;