4 Replies Latest reply on Feb 5, 2014 5:24 PM by Bora Beran

    Custom SQL - calling a sproc

    Bruno Vais

      Hi,

      Is there any way to call a sproc in the Custom SQL section when setting up a connection?

      I tried "exec mySproc parm1, parm2", but I'm getting the following errors:

       

      SQL Server database error 0x80040E14: Incorrect syntax near ')'.

      SQL Server database error 0x80040E14: Incorrect syntax near the keyword 'EXEC'.

      Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.

       

      thanks