Displaying 1 result from an estimated 1 matches for "openquery".
Did you mean:
openquark
2004 Jul 01
0
MS OLAP -- RODBC to SQL Server "Slice Server" pass-through query to MS OLAP
...the DB server side."
Although you can use the MS SQL OPENROWSET() function to set up an ad hoc
connection, the
recommended method would be two steps:
1. Set up a Linked Server using either MS SQL Enterprise Manager or
MS SQL system stored procedure EXEC sp_addlinkedserver.
2. Use an OPENQUERY() function (which works with any OLE DB data source)
to pass the MDX query and
return a resultset. The OPENQUERY function can be used in the "FROM
clause" of a SQL query,
a "stored procedure" or in MS SQL 2000 a "User Defined Function (UDF)."
Also note,
"A...