Support Postgresql Stored Procedure execution error in VBA

From: hemant Kawalkar <kawalkar(dot)hemant(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Support Postgresql Stored Procedure execution error in VBA
Date: 2022-05-21 19:44:12
Message-ID: CAJJN2QHuNSmyCso9VA0H-_cFgh7VK2KhSXyadrR3v2KS++k1RA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Dear All,

0
<https://stackoverflow.com/posts/72332707/timeline>

I am trying to execute a Postgresql stored procedure in Excel VBA, but I am
getting the following error:

*duplicatefilechecksp is procedure(); error while executing the query.*

PFB code :

Dim conSQL As New ADODB.ConnectionDim cmd As New
ADODB.CommandDim Rs As New ADODB.RecordsetDim
strErrDescSP As String ' Set Error Description of SP

With cmd
.ActiveConnection = mod_General.RecturnMSSQLCon
.CommandType = adCmdStoredProc
.CommandText = "duplicatefilechecksp_test"
.ExecuteEnd With

Kindly assist me with query.

regards,

Hemant

<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Browse pgsql-odbc by date

  From Date Subject
Next Message Ravi Narayanaswamy 2022-06-26 04:03:05 PostGres ODBC configuration with OpenText
Previous Message Dirk Hasenbrink 2022-05-20 07:37:32 Bug in psqlodbc 13.02? Bulk updates + ODBC function SQLRowCount(...)