Not able to Run Stored Procedure in SQL Server from AA

[sudhiryes]

Hi,

I am using Automation Anywhere 5.0.
I tried to connect to the SQL Server using the following connection String
---------------------------------------------------------------------------
Provider=SQLOLEDB.1;Password=servion123;Persist Security Info=True;User ID=AA;Initial Catalog=TestDB;Data Source=172.42.173.240;Network Address=172.42.173.240;Application Name=Automation Anywhere 5.0.
----------------------------------------------------------------------------
I have a few stored procedures that i need to call.i used "Run Stored Procedure".But i am getting the following error when i run the Task
"The Connection Cannot be used to perform this operation.It is either closed or invalid in this context"

Note: The connection is not closed.I am able to execute SQL queries in the same place but not stored procedures.

Please help me out!!!

[forumsupport]

Hello,

Can you please upload the task that you have created so far so we can have a look.

You can locate your task by selecting your task from Task List, right clicking that particular task and selecting 'Locate on disk' from context menu.

It would help us investigate further.