We are trying to run a sql statment against a multi language cube.

PTS works fine on two machines with the two different languages - returning two different sets of member names

When we run an MDX statement using ADO MD (opening a cellset) it states it cannot find the member on the non default langage PC, however if we use the default lanaguge on the non default languge PC it works.

This implies to me ADO MD is querying against the default langauge of the cube rather than the other language.

Do we need to set the connection to use a different member based on the locale or should it do it automatically

Thanks

p.s. we are using member names not keys.