Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-odbc-owner+archive@lists.postgresql.org>)
	id 1qiW9c-006f3Q-54
	for pgsql-odbc@arkaria.postgresql.org; Tue, 19 Sep 2023 08:32:20 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-odbc-owner+archive@lists.postgresql.org>)
	id 1qiW9a-007tvr-Oc
	for pgsql-odbc@arkaria.postgresql.org; Tue, 19 Sep 2023 08:32:18 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <alximik328@yandex.ru>)
	id 1qiW9a-007tvg-FP
	for pgsql-odbc@lists.postgresql.org; Tue, 19 Sep 2023 08:32:18 +0000
Received: from forward102b.mail.yandex.net ([178.154.239.149])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <alximik328@yandex.ru>)
	id 1qiW9X-0064fk-7c
	for pgsql-odbc@postgresql.org; Tue, 19 Sep 2023 08:32:17 +0000
Received: from mail-nwsmtp-mxback-production-main-70.myt.yp-c.yandex.net
 (mail-nwsmtp-mxback-production-main-70.myt.yp-c.yandex.net
 [IPv6:2a02:6b8:c12:2381:0:640:de8d:0])
	by forward102b.mail.yandex.net (Yandex) with ESMTP id 2D82F6004B
	for <pgsql-odbc@postgresql.org>; Tue, 19 Sep 2023 11:32:12 +0300 (MSK)
Received: from mail.yandex.com (2a02:6b8:c12:6225:0:640:4bda:0
 [2a02:6b8:c12:6225:0:640:4bda:0])
	by mail-nwsmtp-mxback-production-main-70.myt.yp-c.yandex.net (mxback/Yandex)
 with HTTP id 8WgV1F1W3eA0-TAmSg98f;
	Tue, 19 Sep 2023 11:32:11 +0300
X-Yandex-Fwd: 1
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail;
	t=1695112331; bh=ZvKVYKRZNcSSCqJ379pF+opPh2/E/NgusF/u0OrrBtE=;
	h=Message-Id:Date:Subject:To:From;
	b=czjIdfFc9pe9sfQP3pvOVhfCIqtPp3D2vvHp2po03tjFuWUeQofPlHls4tmINCuaJ
	 wP/nxGuYiHXVOuJLQ35Z8w8To7X3HNN26tViBuHjHuiu24EgzFGVuEHNrV4UVkZrl8
	 HCB3KCblS7amf0dEkTW7rwT7nCNf6fBTZNEFq45Y=
Authentication-Results: 
 mail-nwsmtp-mxback-production-main-70.myt.yp-c.yandex.net;
 dkim=pass header.i=@yandex.ru
Received: by xs3ef5pge24bajlc.myt.yp-c.yandex.net with HTTP;
	Tue, 19 Sep 2023 11:32:11 +0300
From: =?utf-8?B?0LHQvtGA0L7QtNC60LjQvSDQnNCw0LrRgdC40Lw=?=
 <alximik328@yandex.ru>
Envelope-From: alximik328@yandex.com
To: "pgsql-odbc@postgresql.org" <pgsql-odbc@postgresql.org>
Subject: SQLDescribeParam returns -1(SQL_ERROR) with ServerSidePrepare=0
MIME-Version: 1.0
X-Mailer: Yamail [ http://yandex.ru ] 5.0
Date: Tue, 19 Sep 2023 15:32:11 +0700
Message-Id: <3256281695111595@mail.yandex.com>
Content-Transfer-Encoding: 8bit
Content-Type: text/html; charset=utf-8
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/3256281695111595%40mail.yandex.com>
Precedence: bulk

<div>Hi,</div><div>I have issue with psqlodbc:</div><div>When I'm preparing statement with psqlodbc interface I call SQLDescribeParam to know about types of params but with option ServerSidePrepare=0(turned off) its return code is -1(SQL_ERROR). I haven't found any mention about these things are linked so I'd like to know if this behaviour is correct and why.</div><div> </div><div>Of course, temporarily solution is to turn ServerSidePrepare on. If this option is turned on everything works and statements are prepared successfully.</div><div> </div><div>Regards,</div><div>Maksim Borodkin</div>