public inbox for [email protected]  

help / color / mirror / Atom feed

From: hemant Kawalkar <[email protected]>
To: [email protected]
Subject: Support Postgresql Stored Procedure execution error in VBA
Date: Sun, 22 May 2022 01:14:12 +0530
Message-ID: <CAJJN2QHuNSmyCso9VA0H-_cFgh7VK2KhSXyadrR3v2KS++k1RA@mail.gmail.com> (raw)

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&...;
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&...;
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Support Postgresql Stored Procedure execution error in VBA
  In-Reply-To: <CAJJN2QHuNSmyCso9VA0H-_cFgh7VK2KhSXyadrR3v2KS++k1RA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox