Unable to connect SQL using UI Path "Execute Query" activity


#1

Hi @badita @vvaidya @aksh1yadav @beesheep @akhi_s27 @Vikas.Jain ,

I have a UI path solution developed on my dev machine which has SQL server running, it works perfectly fine connecting to database and retrieving the results.

The same solution I tried on my other machine which has the same SQL server and the database configured but it is not working here failing at “Extract Query” activity.

Error: Invoke Database Iteration workflow file: Execute query : Object reference not set to an instance of an object.

Can someone share your thoughts, what could be the issue.

I have done my part of goolging already and couldn’t really identify what the issue is, any help is highly appreciable,

Thanks!


#2

It might be an environment issue ?

can you please check

c:\Windows\system32\odbcad32.exe and also provide the query you are executing?