Hello all,
I am trying to update an existing report however when I insert a new query and I choose the same OCE just like the existing queries I am getting an error.
Once I choose the OCE I am able to see the tables in the elements section however when I drag and drop a table the message below is displayed. (See attached image)
Server Error: 1012 - Error while executing the query
The OCE allows me to run the existing queries with no problem. Also this OCE connects to a PostgreSQL database and when I use another OCEs to SQL Server or Oracle I don't have any problem.
Could someone shed a light for this issue? Could it be a problem related to the user that the ODBC is using?
Thanks
Audrey