Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mRBPJ-0001mG-Ct for pgsql-odbc@arkaria.postgresql.org; Fri, 17 Sep 2021 10:47:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mRBPI-0003Ez-Bi for pgsql-odbc@arkaria.postgresql.org; Fri, 17 Sep 2021 10:47:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mRBPH-0003Ei-UQ for pgsql-odbc@lists.postgresql.org; Fri, 17 Sep 2021 10:47:48 +0000 Received: from mx08-00574e01.pphosted.com ([185.183.31.38]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mRBPB-0006G6-6n for pgsql-odbc@postgresql.org; Fri, 17 Sep 2021 10:47:45 +0000 Received: from pps.filterd (m0213998.ppops.net [127.0.0.1]) by mx08-00574e01.pphosted.com (8.16.1.2/8.16.1.2) with SMTP id 18H6Q8MT003306 for ; Fri, 17 Sep 2021 11:47:37 +0100 Received: from mail-wr1-f70.google.com (mail-wr1-f70.google.com [209.85.221.70]) by mx08-00574e01.pphosted.com with ESMTP id 3b483rhh66-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128 verify=NOT) for ; Fri, 17 Sep 2021 11:47:37 +0100 Received: by mail-wr1-f70.google.com with SMTP id m1-20020a056000180100b0015e1ec30ac3so3567509wrh.8 for ; Fri, 17 Sep 2021 03:47:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=iress-com.20210112.gappssmtp.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=K6UEuWzgwencMEdzN+Hnihd43d8INaCmjsiUBPQdLtM=; b=ThhuOLI1eRlKoz9hPy9o9gw0gdFn5ebt9dk2iUR7KHFQR6t3Zjwl/NWB2eGmylPopy DUYQa7EzzZ08eh6ZUsDOh0yaz/Iz5hlhKM/sMxPxTCsz05umW5GtplysJEZVXjBxo1/X 9LJeycH8OVdnAH3qjynVZfVJFvLhcwszZ/bPHALBlKE2lSu0k9OtMy9wRcfOGuIzllHX cHjRHtnlWYyvgsCrcasIzlTCeZGe8YR7APAnP/zDhjgTWYT2dkHS7II2Oblgk/O/JrJ8 /z1mxnyCb38kjfVyjDH613Do58au8MkYMm7dLkzZX53sk7N9a531nLh7GCwC9OiP7KBo i0Mw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=K6UEuWzgwencMEdzN+Hnihd43d8INaCmjsiUBPQdLtM=; b=L7bFZQozl42c9xYxA1Gza5yrOGfQ+HpgKxWVTjYH8/NfkVt186aQXKUP0tWW1CMxEO pWtpITWM93HiUEd+OHko7oSr6Je2se0yCjRf6U3AM7jtEo0yJghGhvGEiZarxspJnBPv 1KcBnr4/KdeVRslk5BNb5gBh85OThR5uQmI/0DlQXLgPGC9Lga1/os+O7zD+v2qVvflo bHKfPvCo68Men/b94d1PICQ9H0PeL7qRhq3H33rXfZRy5nOiDmfGEjXU6HwgTxAkBm6Q yM8TLz+Mr42DR1xbnaCLw1vVpfmcAd47kpeZDN0kBsSrVIhYPBErMFkkiH6F3W3PeoT3 AlFA== X-Gm-Message-State: AOAM532YLYeYfdsO1XuFAjj7eyWvBqDuDP0Ye1xVnsr5uxs2ZLOLDpQa /JVab4HQlmQpYCaUIeLbSlKpNXls2KFBM4QI3RaefZAnEEmUDqWmw6j9Hvm7RTtwS7usl94A196 cNlt2rmERymKvNRN/tUzm7awE66Qj8l6CyEhA6x6YEcFAuQ== X-Received: by 2002:a05:6000:1207:: with SMTP id e7mr11155144wrx.170.1631875656432; Fri, 17 Sep 2021 03:47:36 -0700 (PDT) X-Google-Smtp-Source: ABdhPJznLr/cjfyUOKBoFasMP1cMabjaJECFvShdNKWKNCOYL+zQcOAMW+lrRAz91BtKtPetIVQageFj0jfZ X-Received: by 2002:a05:6000:1207:: with SMTP id e7mr11155114wrx.170.1631875656001; Fri, 17 Sep 2021 03:47:36 -0700 (PDT) Received: from eu2.smtp.exclaimer.net (eu2.smtp.exclaimer.net. [52.169.0.179]) by smtp-relay.gmail.com with ESMTPS id t6sm224091wre.86.2021.09.17.03.47.35 for (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 17 Sep 2021 03:47:35 -0700 (PDT) X-Relaying-Domain: iress.com Received: from mail-wm1-f70.google.com (209.85.128.70) by eu2.smtp.exclaimer.net (52.169.0.179) with Exclaimer Signature Manager ESMTP Proxy eu2.smtp.exclaimer.net (tlsversion=TLS12, tlscipher=TLS_ECDHE_WITH_AES256_SHA1); Fri, 17 Sep 2021 10:47:35 +0000 X-ExclaimerHostedSignatures-MessageProcessed: true X-ExclaimerProxyLatency: 7512550 X-ExclaimerImprintLatency: 4904209 X-ExclaimerImprintAction: 23e9de3152e14fa18d4e6c09155d69e5 Received: by mail-wm1-f70.google.com with SMTP id 201-20020a1c04d2000000b0030b3e4fdcfbso1682225wme.0 for ; Fri, 17 Sep 2021 03:47:35 -0700 (PDT) X-Received: by 2002:a05:6000:1866:: with SMTP id d6mr3145287wri.141.1631875654317; Fri, 17 Sep 2021 03:47:34 -0700 (PDT) X-Received: by 2002:a05:6000:1866:: with SMTP id d6mr3145233wri.141.1631875653600; Fri, 17 Sep 2021 03:47:33 -0700 (PDT) MIME-Version: 1.0 References: <994c12dd0d6348d389246fda802fff07@exmbx03.ofis.int> <20f6a96a81274049a0b9eacdf79bce20@exmbx03.ofis.int> In-Reply-To: <20f6a96a81274049a0b9eacdf79bce20@exmbx03.ofis.int> From: Adrian Grucza Date: Fri, 17 Sep 2021 20:47:22 +1000 Message-ID: Subject: Re: Problem on calling procedures with ADODB To: Kamil ADEM Cc: "pgsql-odbc@postgresql.org" , Haluk DALKIRAN Content-Type: multipart/related; boundary="000000000000a758bd05cc2ea858" X-Proofpoint-GUID: FyKMFM2VV8ABVat2o8smBBYwv2HBMz_4 X-Proofpoint-ORIG-GUID: FyKMFM2VV8ABVat2o8smBBYwv2HBMz_4 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --000000000000a758bd05cc2ea858 Content-Type: multipart/alternative; boundary="000000000000a758ba05cc2ea857" --000000000000a758ba05cc2ea857 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi Kamil, That particular commit does actually depend on the previous commit. But to fix your particular problem, you should only need the below change (which doesn't have dependencies): --- a/statement.c +++ b/statement.c @@ -56,6 +56,9 @@ static const struct ,{ STMT_TYPE_DELETE, "DELETE" } + ,{ + STMT_TYPE_PROCCALL, "CALL" + } ,{ STMT_TYPE_PROCCALL, "{" } Alternatively, just build with the latest code from the master branch. I'm not part of the psqlODBC team so I'm not aware of the release schedule. But whenever a new version is released, a message is posted on this mailing list, so just stay subscribed. Adrian Grucza Technical Lead Tel: +61390185800 The contents of this email originated from Iress. For this purpose Iress in= cludes Iress Limited and/or any of its subsidiaries, holding companies and = trading entities. =E2=80=8B=E2=80=8BIf you have received this email in error please notify th= e sender immediately and delete this email. On Fri, 17 Sept 2021 at 17:43, Kamil ADEM wrote= : > > > *CAUTION: *This Email is from an EXTERNAL source. Ensure you trust this > sender before clicking on any links or attachments. > > > Hi Adrian, > > > > Thank you for your comment. > > I will work for our own version to include your fix. I hope this fix has > no dependencies to other fixes not included in the source code I have. I > think I can ask for help from you if I get a problem when building and > testing. > > > > We also are very keen to have a recent release that contains all the > recent fixes. We are going to publish our old application with a new > PostgreSQL interface and want to have a solid working environment. > > How can we follow the release schedule? Is there an automatic mechanism o= r > can you inform us when a new release comes out? > > > > Kamil Adem > > Aqvila Software Yaz=C4=B1l=C4=B1m A.=C5=9E. > > > > > > *From:* Adrian Grucza > *Sent:* Friday, September 17, 2021 2:21 AM > *To:* Kamil ADEM > *Cc:* pgsql-odbc@postgresql.org > *Subject:* Re: Problem on calling procedures with ADODB > > > > Hi Kamil, > > > > Yes I also found that output parameters were not processed when calling > procedures. In May I included a fix for this in the below commit, but the= re > has not been a release of psqlODBC since then. > > > > > https://git.postgresql.org/gitweb/?p=3Dpsqlodbc.git;a=3Dcommit;h=3D241c70= bf6516bf08770fabcb1b86934c8da116c8 > > > > > Until this change is released, you would have to build your own version o= f > the driver as per https://odbc.postgresql.org/docs/win32-compilation.html > > > > > But I do hope there will be a new release soon, as I too am keen to have > an official release that contains this fix. > > > > > > > > [image: Image removed by sender.] > > *Adrian Grucza* > > Technical Lead > > Tel: > > +61390185800 > > The contents of this email originated from Iress. For this purpose Iress > includes Iress Limited and/or any of its subsidiaries, holding companies > and trading entities. > If you have received this email in error please notify the sender > immediately and delete this email. > > On Thu, 16 Sept 2021 at 23:23, Kamil ADEM > wrote: > > > > *CAUTION: *This Email is from an EXTERNAL source. Ensure you trust this > sender before clicking on any links or attachments. > > > > Hi Adrian, > > > > Thank you very much for your support. > > > > Yes, I tried setting CommandText as you propose and succeeded to call the > procedure. But I got another minor problem this time. I hope you have a > solution for this too. =F0=9F=98=8A > > To be more clear, here are the source codes: > > Postgres procedure: > > CREATE OR REPLACE PROCEDURE public.SP_TEST(INOUT VALUE_INOUT INTEGER, IN > USERNAME VARCHAR(50)) > > LANGUAGE plpgsql > > AS $$ > > BEGIN > > insert into tohal_kullanici (satis_faturasi_sira_no, ad) > values (VALUE_INOUT, USERNAME); > > VALUE_INOUT :=3D 20; > > RETURN; > > END; $$; > > MFC code: > > _CommandPtr pCommand; > > pCommand->CommandType =3D adCmdText; > > pCommand->CommandText =3D _bstr_t("CALL SP_TEST(?, ?)"); > > pCommand->Parameters->Append(pCommand->CreateParameter(_bstr_t("$1"), > adInteger, adParamInputOutput, 0)); > > pCommand->Parameters->Append(pCommand->CreateParameter(_bstr_t("$2"), > adVarChar, adParamInput, 255)); > > pCommand->Parameters->Item[_variant_t((long)1)]->Value =3D > _variant_t(CString("Test10")); > > pCommand->Parameters->Item[_variant_t((long)0)]->Value =3D > _variant_t((long)10); > > pCommand->Execute(NULL, NULL, adCmdText); > > > > The procedure is called and the parameter values are passed correctly to > the procedure. But the first parameter value is not returned to the C cod= e, > the value set before Execute() remains unchanged. > > Do you have any idea about the reason of this case? > > > > Thanks in advance. > > > > Kamil Adem > > > > > > *From:* Adrian Grucza > *Sent:* Thursday, September 16, 2021 2:07 PM > *To:* Kamil ADEM > *Cc:* pgsql-odbc@postgresql.org > *Subject:* Re: Problem on calling procedures with ADODB > > > > Hi Kamil, > > > > Have you tried changing pCommand->CommandText to _bstr_t("CALL sp_TEST(?, > ?, ?)"), with one question mark per parameter? > > > > [image: Image removed by sender. iress.com] > > *Adrian Grucza * > > Technical Lead > > Tel: > > +61390185800 > > *adrian.grucza@iress.com* > > *www.iress.com* > > Level 16 385 Bourke St > > Melbourne, > > Victoria, > > 3000 > > The contents of this email originated from Iress. For this purpose Iress > includes Iress Limited and/or any of its subsidiaries, holding companies > and trading entities. If you have received this email in error please > notify the sender immediately and delete this email. > > nosig > > On Thu, 16 Sept 2021 at 17:49, Kamil ADEM > wrote: > > > > *CAUTION: *This Email is from an EXTERNAL source. Ensure you trust this > sender before clicking on any links or attachments. > > > > Hello, > > > > We porting a Windows MFC application from MSSQLServer to PostgreSQL and > trying to use psqlODBC driver with Microsoft ADODB. > > We are currently performing the migration steps of our C sources and got > stuck on an issue and thought to ask for your help. > > > > We use Microsoft ADODB on Windows to access the database and cannot chang= e > this interface in short time. To access Postgres we changed the connectio= n > string accordingly. (e.g. =E2=80=9CDriver=3D {PostgreSQL ANSI};=E2=80=9D) > > On calling Postgres procedures we have the following code sample: > > _CommandPtr pCommand; > > pCommand->CommandType =3D adCmdStoredProc; > > pCommand->CommandText =3D _bstr_t(=E2=80=9Csp_TEST=E2=80=9D); > > pCommand->Parameters->Refresh(); > > pCommand->Execute(NULL, NULL, adCmdStoredProc | adExecuteNoRecords); > > The Execute() method generates the command: =E2=80=9CSELECT * FROM sp_TES= T(=E2=80=A6)=E2=80=9D > instead of =E2=80=9CCALL sp_TEST(=E2=80=A6)=E2=80=9D. This is appropriate= for Postgres functions, > but there must be a way to call procedures also. > > Do you know such a reported issue? Do you know a way to change this > behaviour? Should we use a different driver? Should we get rid of > procedures and convert our MSSQL stored procedures to Postgres functions? > > > > We would be grateful if you can guide us to the right solution. > > Thanks in advance. > > > > Best regards, > > > > Kamil Adem > > Aqvila Software Yaz=C4=B1l=C4=B1m A.=C5=9E. > > > > > > > > --000000000000a758ba05cc2ea857 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Hi Kamil,

That particular commit does actually depend on the = previous commit. But to fix your particular problem, you should only=C2=A0n= eed the below change (which doesn't have dependencies):

<= /div>
--- a/statement.c
+++ b/statement.c
@@ -56,6 +56,9 @@=C2=A0static=C2=A0const=C2=A0struct
=
=C2=A0=C2=A0=C2=A0=C2=A0,{
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0STMT_TYPE_DELETE,= =C2=A0"DELETE"
=C2=A0=C2=A0=C2=A0= =C2=A0}
+=C2=A0=C2=A0=C2=A0,{
+=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0STMT_TYPE_P= ROCCALL,=C2=A0"CALL"
+=C2=A0=C2= =A0=C2=A0}
=C2=A0=C2=A0=C2=A0=C2=A0,{
<= div class=3D"gmail-diff gmail-ctx" style=3D"font-family:monospace;white-spa= ce:pre;color:rgb(0,0,0)">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0ST= MT_TYPE_PROCCALL,=C2=A0"{"
=C2=A0= =C2=A0=C2=A0=C2=A0}

Alternatively, just buil= d with the latest code from the master branch.

I&#= 39;m not part of the psqlODBC team so I'm not aware of the release sche= dule. But whenever a new version is released, a message is posted on this m= ailing list, so just stay subscribed.


3D"=
<= tr style=3D"font-size:12px;">
Adrian Grucza​<= /span>
= Technical Lead
Tel: +613= 90185800
<= table cellpadding=3D"0" cellspacing=3D"0" border=3D"0" style=3D"width:100%;= font-size:0;">
=
The contents = of this email originated from Iress. For this purpose Iress includes Iress = Limited and/or any of its subsidiaries, holding companies and trading entit= ies.
​​If you have received this email in error please not= ify the sender immediately and delete this email. 
<= /td>
On Fri, 17 Sept = 2021 at 17:43, Kamil ADEM <= kamila@aqvilasoftware.com> wrote:


CAU= TION: This Email is from an EXTERNAL source. Ensure you trust th= is sender before clicking on any links or attachments.


Hi Adrian,=

=C2=A0

Thank you for your comment.<= /u>

I will work for our own version= to include your fix. I hope this fix has no dependencies to other fixes no= t included in the source code I have. I think I can ask for help from you i= f I get a problem when building and testing.

=C2=A0

We also are very keen to have a= recent release that contains all the recent fixes. We are going to publish= our old application with a new PostgreSQL interface and want to have a sol= id working environment.

How can we follow the release s= chedule? Is there an automatic mechanism or can you inform us when a new re= lease comes out?

=C2=A0

Kamil Adem=

Aqvila Software Yaz=C4=B1l=C4= =B1m A.=C5=9E.

=C2=A0

=C2=A0

From: Adrian Grucza <adrian.grucza@iress.com>
Sent: Friday, September 17, 2021 2:21 AM
To: Kamil ADEM <kamila@aqvilasoftware.com>
Cc: p= gsql-odbc@postgresql.org
Subject: Re: Problem on calling procedures with ADODB<= /span>

=C2=A0

Hi=C2=A0Kamil,

=C2=A0

Yes I also found that output parameters were not pro= cessed when calling procedures. In May I included a fix for this in the bel= ow commit, but there has not been a release of psqlODBC since then.<= u>

=C2=A0

=C2=A0

Until this change is released, you would have to bui= ld your own version of the driver as per=C2=A0https://odbc.postgresql.org/docs/win32-compilation.html=

=C2=A0

But I do hope there will be a new release soon, as I= too am keen to have an official release that contains this fix.<= /u>

=C2=A0

=C2=A0

=C2=A0

3D"Image

Adrian=C2=A0Grucza<= b>

Technical=C2=A0Lead

Tel:=C2=A0

+61390185800

The contents of this email o= riginated from Iress. For this purpose Iress includes Iress Limited and/or = any of its subsidiaries, holding companies and trading entities.
If you have received this email in error please notify the sender immediate= ly and delete this email.=C2=A0

On Thu, 16 Sept 2021 at 23:23, Kamil ADEM <kamila@aqvilasoftw= are.com> wrote:

=C2=A0

CAUTION: This Email is from an EXTERNAL source. Ensure you trust this sen= der before clicking on any links or attachments.

=C2=A0

Hi Adrian,=

=C2=A0

Thank you very much for your su= pport.

=C2=A0

Yes, I tried setting CommandTex= t as you propose and succeeded to call the procedure. But I got another min= or problem this time. I hope you have a solution for this too. =F0=9F=98=8A

To be more clear, here are the = source codes:

Postgres procedure:

CREATE OR REPLACE PROCEDURE public.SP_TEST(INOUT VALUE= _INOUT INTEGER, IN USERNAME VARCHAR(50))

LANGUAGE plpgsql

=C2=A0=C2=A0 AS $$

BEGIN

=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 insert into tohal_kullanici (satis_= faturasi_sira_no, ad) values (VALUE_INOUT, USERNAME);<= /p>

=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 VALUE_INOUT :=3D 20;<= u>

=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 RETURN;

END; $$;

MFC code:<= /p>

_CommandPtr pCommand;

pCommand->CommandType =3D adCmdText;<= u>

pCommand->CommandText =3D _bstr_t("CALL SP_TES= T(?, ?)");

pCommand->Parameters->Append(pCommand->Create= Parameter(_bstr_t("$1"), adInteger, adParamInputOutput, 0));

pCommand->Parameters->Append(pCommand->Create= Parameter(_bstr_t("$2"), adVarChar, adParamInput, 255));

pCommand->Parameters->Item[_variant_t((long)1)]-= >Value =3D _variant_t(CString("Test10"));=

pCommand->Parameters->Item[_variant_t((long)0)]-= >Value =3D _variant_t((long)10);

pCommand->Execute(NULL, NULL, adCmdText);=

=C2=A0

The procedure is called and the= parameter values are passed correctly to the procedure. But the first para= meter value is not returned to the C code, the value set before Execute() remains unchanged.

Do you have any idea about the = reason of this case?

=C2=A0

Thanks in advance.

=C2=A0

Kamil Adem=

=C2=A0

=C2=A0

=C2=A0

Hi Kamil,

=C2=A0

Have you tried changing pCommand->CommandText to = _bstr_t("CALL sp_TEST(?, ?, ?)"), with one question mark per para= meter?

=C2=A0

3D"Ima=

Adrian=C2=A0Grucza=C2=A0=C2=A0<= /u>

Technical=C2=A0Lead

Tel:=C2=A0

+61390185800

adrian.g= rucza@iress.com

www.iress.com

Level=C2=A016=C2=A0385=C2=A0Bourke=C2=A0St

=C2=A0Melbourne,=C2=A0

Victoria,=C2=A0

3000

The contents of this email originated from Iress. F= or this purpose Iress includes Iress Limited and/or any of its subsidiaries= , holding companies and trading entities. If you have received this email in error please notify the sender immediat= ely and delete this email.=C2=A0

nosig

On Thu, 16 Sept 2021 at 17:49, Kamil ADEM <kamila@aqvilasoftw= are.com> wrote:

=C2=A0

=0D=0A

CAUTION: This Email is from an EXTE= RNAL source. Ensure you trust this sender before clicking on any links or a= ttachments.

=C2=A0

Hello,

=C2=A0

We porting a Windows MFC applic= ation from MSSQLServer to PostgreSQL and trying to use psqlODBC driver with= Microsoft ADODB.

We are currently performing the= migration steps of our C sources and got stuck on an issue and thought to = ask for your help.

=C2=A0

We use Microsoft ADODB on Windo= ws to access the database and cannot change this interface in short time. T= o access Postgres we changed the connection string accordingly. (e.g. =E2=80=9CDriver=3D {PostgreSQL ANSI};=E2=80=9D)=

On calling Postgres procedures = we have the following code sample:

_CommandPtr pCommand;

pCommand->CommandType =3D adCmdStoredProc;

pCommand->CommandText =3D _bstr_t(=E2=80=9Csp_TEST= =E2=80=9D);

pCommand->Parameters->Refresh();

pCommand->Execute(NULL, NULL, adCmdStoredProc | adE= xecuteNoRecords);

The Execute() method generates = the command: =E2=80=9CSELECT * FROM sp_TEST(=E2=80=A6)=E2=80=9D instead of = =E2=80=9CCALL sp_TEST(=E2=80=A6)=E2=80=9D. This is appropriate for Postgres= functions, but there must be a way to call procedures also.

Do you know such a reported iss= ue? =C2=A0Do yo= u know a way to change this behaviour? Should we use a different driver? Sh= ould we get rid of procedures and convert our MSSQL stored procedures to Po= stgres functions?

=C2=A0

We would be grateful if you can guide us to the = right solution.

Thanks in advance.

=C2=A0

Best regards,<= /u>

=C2=A0

Kamil Adem=

Aqvila Software Yaz=C4=B1l=C4= =B1m A.=C5=9E.

=C2=A0

=C2=A0

=C2=A0

--000000000000a758ba05cc2ea857-- --000000000000a758bd05cc2ea858 Content-Type: image/jpeg; name="~WRD0004.jpg" Content-Disposition: inline; filename="~WRD0004.jpg" Content-Transfer-Encoding: base64 Content-ID: <17bf3540f23bf1b4b821> X-Attachment-Id: 17bf3540f23bf1b4b821 /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCABkAGQDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo ooAKKKKACiiigAooooAKKKKACiiigD//2Q== --000000000000a758bd05cc2ea858--