I have also seen strange things happen in the scheduler when running macros. Try using a User DSN entry for your catalog source if you're not doing so.
hope you find a solution.
I did what suggested earlier and tried this again with the update statement in the strQuery variable... but I get an error. Do you know if there's some other variable or another execute command that has to be used for an update statment to work?
thanks.
I'm trying to open an ODBC connection to an oracle database from a macro that automates Transformer Cube builds....In the Macro I also need to update a table on the database side with cube success/failure information. I have already coded the select statement that returns rows after opening an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.