ODBC Connect to SQL Server Issue Executing Analyst macro W/In Contributor Macro

[sleeaptina]

I have an Analyst macro where the 1st step is to ODBC connect to the data warehouse on SQL server to grab data.

The Analyst macro runs fine when I manually run it from Analyst (I'm running Analyst 8.4).

When I try to execute the Analyst macro within a Contributor macro, I receive the error:  "Unable to execute macro <macro name>.  The return code was 1107."

I checked various websites and saw that system/user DSN was an issue for many, but I checked mine and it is correct.

Any ideas?

[John 27182]

I had a similar problem a few months ago. Below is a solution which worked for me.

http://www.cognoise.com/community/index.php/topic,13743.0.html