Problem on calling procedures with ADODB

From: Kamil ADEM <kamila(at)aqvilasoftware(dot)com>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Problem on calling procedures with ADODB
Date: 2021-09-16 07:49:34
Message-ID: 994c12dd0d6348d389246fda802fff07@exmbx03.ofis.int
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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 change this interface in short time. To access Postgres we changed the connection string accordingly. (e.g. "Driver= {PostgreSQL ANSI};")
On calling Postgres procedures we have the following code sample:
_CommandPtr pCommand;
pCommand->CommandType = adCmdStoredProc;
pCommand->CommandText = _bstr_t("sp_TEST");
pCommand->Parameters->Refresh();
pCommand->Execute(NULL, NULL, adCmdStoredProc | adExecuteNoRecords);
The Execute() method generates the command: "SELECT * FROM sp_TEST(...)" instead of "CALL sp_TEST(...)". 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ılım A.Ş.

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Adrian Grucza 2021-09-16 11:06:51 Re: Problem on calling procedures with ADODB
Previous Message Andreas Beier 2021-09-09 08:46:17 Re: Excel ODBC query loosing parameter when returning the query result directly to a pivot table.