Обсуждение: Support Postgresql Stored Procedure execution error in VBA

Поиск
Список
Период
Сортировка

Support Postgresql Stored Procedure execution error in VBA

От
hemant Kawalkar
Дата:
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