Hello,

I'm currently running VC 6.1.8. I want to create a task that pulls data out of a Postgres DB.

I tried two different types of connections
1. using SQL Explorer and the connection guide in VC, this failed miserably. It would not connect no matter what I tried.
2. I used an ODBC connection and the 64 bit postgres odbc drivers. This allowed me to connect to the database by choosing the use existing data source in the connection wizard.

Once connected I tried to view the contents of multiple tables - this is the error that was returned: "Object reference not set to an instance of an object. UCQueryControl.UCQueryControl_Load"

Any help would be appreciated.

Thanks,
Paul

We will try to reproduce this. Is the actual Task(s) working fine now?

---

Hi Henrik,

Thank you for your response.

The task is not working at all. In order to move forward I need to be able to query the db.

Regards,
Paul

FYI - I also just upgraded to 6.1.9 - same issue.

Ok, but if you ignore errors in the Client - what error do you get with the Task?

---

My apologies - I set up the connection and tried to use SQL Explorer to define my query prior to creating the task. There is no task associated with this.

Thanks,
Paul

I am talking about the SQL Task. The SQL Explorer is just a tool. It is secondary in our eyes because has nothing to do with automation but more just testing the actual Connection.

So, is the SQL Task working for you?

---

This can be closed. Using a Postgres database you need to know the schema associated with the database connection. Trying to do a standard select statement requires the schema.tablename - using just the tablename will cause connection errors.

ex. I was using select * from tablename - this was causing the error above. I then did a select at a higher level to list out all schemas and tables --> select * from information_schema.tables - this brought back a listing of all the table catalogs, the table schema and the table name. I then used the combination of the table schema and the table name in the select statement and that allowed me to query the table I needed --> select * from schema.tablename

Thanks for your help - it forced me to look into what was actually happening.

Regards,
Paul