Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: sleeaptina on 15 Apr 2011 05:46:27 PM

Title: ODBC Connect to SQL Server Issue Executing Analyst macro W/In Contributor Macro
Post by: sleeaptina on 15 Apr 2011 05:46:27 PM
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?
Title: Re: ODBC Connect to SQL Server Issue Executing Analyst macro W/In Contributor Macro
Post by: John 27182 on 23 May 2011 11:12:39 AM
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
Text only | Text with Images