Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
I am not talking about connection problem. The problem was it was impossible to set the needed properties of the recordset and to get the proper result. Using the second approach (as I explained) for all objects involved, for connection and for recordset, helped to resolve the issue.
>My problem is not connecting, it's when the "UPDATE" command in my Stored Procdure fires, the rest of the code in the Stored Procdure is skipped (for a better use of words) when calling the stored procdure via ADODB. If I call the stored procedure via ODBC, all the lines execute.
>
>I hope I better explained my problem.
>
>Thanks
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement