Support Postgresql Stored Procedure execution error in VBA - Mailing list pgsql-odbc

From hemant Kawalkar
Subject Support Postgresql Stored Procedure execution error in VBA
Date
Msg-id CAJJN2QHuNSmyCso9VA0H-_cFgh7VK2KhSXyadrR3v2KS++k1RA@mail.gmail.com
Whole thread Raw
List pgsql-odbc
Dear All,

0

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.Connection
Dim cmd             As New ADODB.Command
Dim Rs              As New ADODB.Recordset
Dim strErrDescSP    As String               ' Set Error Description of SP


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

Kindly assist me with query.

regards,
Hemant

Virus-free. www.avast.com

pgsql-odbc by date:

Previous
From: Dirk Hasenbrink
Date:
Subject: Bug in psqlodbc 13.02? Bulk updates + ODBC function SQLRowCount(...)
Next
From: Ravi Narayanaswamy
Date:
Subject: PostGres ODBC configuration with OpenText