Select query in Uiapth to retrieve data from database

[vini93]

Hi. Im having error with my select query in UiPath.

My SQL Query:

“SELECT [FundManagerID] FROM [dbo.FundManagers]”

Error: Execute Query: Invalid object name ‘dbo.FundManagers’.

[vini93]

@Palaniyappan @BenMar

[Ankumarm (Anil Kumar M)]

@vini93 ,

Check whether you have table “FundManagers” In SQL ?

[vini93]

Yes I do @Ankumarm

[kadiravan_kalidoss (Kadiravan K)]

Select querry in SQL Server using Execute Command

Hi, Check if the connection is still open, or somewhere on the line you closed the connection, for me that was the issue . Hope this may help you ! ( also if the connection is not open then the query won’t work) Regards, Serban

[Palaniyappan (Palaniyappan P)]

Is this query executing in sql server database
Kindly check there once
If that works then it will work here for sure
Cheers @vini93

[lakshman (Ganta lakshman)]

@vini93

Try below Query.

  “SELECT [FundManagerID] FROM [dbo].[FundManagers]”