How can we use pgSQL in Automation Anywhere?

Question

I have created DLL using pgSQL(to read data and return to Automation Anywhere) and I am trying to use it in an Automation anywhere bot. But it shows an error:

Could not load file or assembly 'npgsql, Version=4.0.2.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7' or one of its dependencies. System cannot find the file specified.

if you have any idea to solve that please help me.

Answer 1

I feel this is a case of missing dependencies so what you need to do is you need to add the dependencies you used whilst creating the DLL into the metabot as well, by uploading them alongside your DLL in the assets view. In this case 'npgsql.dll'.

If you've built the DLL on another machine, you can - in addition to the steps above - also try adding the dependent DLLs to the PATH.