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>
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(...) |