Ciao a tutti!

Ho realizzato un piccolissimo script che mi deve interrogare un cubo.

if($conn){

print "TRUE = ".$conn."
";

mssql_query('SET ANSI_NULLS ON');
mssql_query('SET ANSI_WARNINGS ON');

$query = mssql_query("SELECT * FROM OPENQUERY(ISADORA, 'SELECT [Measures].[Transactions] ON COLUMNS , CAST([Company].MEMBERS , TEXT) ON ROWS FROM [Es]')", $conn);

if($query){
print "OK QUERY".$query."
";
$result = mssql_fetch_array($query);
print_r($result);

print "ERROR QUERY
";
}

mssql_close($conn);

} else {
print "FALSE = ".$conn;
}

Purtroppo però ho un problema sulla query (e credo sul CAST).
L'output è:

Warning: mssql_query() [function.mssql-query]: message: An error occurred while preparing the query "SELECT [Measures].[Transactions] ON COLUMNS , CAST([Company].MEMBERS , TEXT) ON ROWS FROM [Es]" for execution against OLE DB provider "MSOLAP" for linked server "ISADORA". (severity 16) in C:\Programmi\DocumentsRoot\provaconnessione.php on line 18

Qualche suggerimento?

Grazie.

Ale