Sean,

Your last post pointed me in the right way.

Installed the following and I can now connect.

msxml6

SQLServer2005_ASOLEDB9

Many thanks

Frank

Hi Sean,

I am connecting via excel (office 2002). I do not get that option.

Thx

Frank

I have ran the above statement and it returns the same error. If I do a simply select statement it returns information so I gather it is due to it...

Again thank you, same results. I have asked an Informix DBA and he has advised that is may be due to teh version of Informix (7.31 UC5) not being able to...

Many thanks for the above - I am running DTS from SQL server 2005 to an old informix database. When I parse the query I get the following message ERROR...

OK think I have got somewhere with this - I have been using a tool called Data Analyzer to connect to AS. It would not show the cube once I...

Thank you for the post. I have already set up a role and attached NT 4 permissions to it for domain access.