ID: 32278
Comment by: cmoore at getzeroedin dot com
Reported By: raulionescu at gmail dot com
Status: No Feedback
Bug Type: MSSQL related
Operating System: WinXP Pro
PHP Version: 5.0.4
New Comment:
I'm experiencing the same error, Warning: mssql_query()
[function.mssql-query]: message: Heterogeneous queries require the
ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This
ensures consistent query semantics. Enable these options and then
reissue your query, when attempting to execute a linked MDX query to SQL
Server Analysis Services (an analytics cube). Below is the query ....
set ANSI_NULLS ON;
set ANSI_ARNINGS ON;
exec sp_addlinkedserver
@server='linked_olap',
@srvproduct='',
@provider='MSOLAP.3',
@datasrc='scout',
@catalog='Adventure Works DW Standard Edition'
;
SELECT *
FROM OpenQuery(linked_olap,'SELECT
{Measures.[Internet Order Count]} ON COLUMNS ,
[Product].[Category].members ON ROWS
FROM [Adventure Works]')
;
exec sp_dropserver 'linked_olap'
;
------------
In the linked server procedure, 'scout' is my database server name, but
Adventure Works is the sample analysis server data warehouse (cube), so
you should be able to recreate this simply.
Are there any plans to support native MDX queries against a SQL Server
Analysis Server, or plans to resolve this issue?
Previous Comments:
------------------------------------------------------------------------
[2008-04-30 16:41:06] webster_jack at hotmail dot com
Hi
Has this bug been fixed?
------------------------------------------------------------------------
[2007-12-12 19:33:37] kenneth dot kaye at bankofamerica dot com
This bug still exists as of PHP 5.1.2. I run PHP(cli) 5.1.2 on Windows
2003 Server, and attempting to execute a stored procedure within PHP
that calls a linked server yields the following error:
PHP Warning: mssql_execute(): message: Heterogeneous queries require
the ANSI_NULLS and ANSI_WARNINGS options to be set
for the connection. This ensures consistent query semantics. Enable
these options and then reissue your query. (severit
y 16) in c:\logs\btest.php on line 46
PHP Warning: mssql_execute(): stored procedure execution failed in
c:\logs\btest.php on line 4
6
PHP Warning: mssql_fetch_array(): supplied argument is not a valid MS
SQL-result resource in c:\logs\btest.php on line 55
I have ANSI_NULLS and ANSI_WARNINGS set within the stored procedure
itself. Any advice or a fix?
------------------------------------------------------------------------
[2006-09-15 13:58:20] redshifteric at gmail dot com
Bug reproduced on Win2k Server
MSSQL 2000 SP3
PHP 5.1.2
I tried using the normal syntax to access table on the linked server.
I mean using linkedservername.databasename.dbo.tablename or directoty
the local tablename but without success.
If i specify the full linked server path, i get the following error:
Could not find server 'KCONT81' in sysservers. Execute
sp_addlinkedserver to add the server to sysservers
But if i execute the same query trough isqlw.exe (query analyzer) it
works fine.
Best regards,
Red
------------------------------------------------------------------------
[2005-06-14 01:00:03] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
------------------------------------------------------------------------
[2005-06-07 00:17:31] [EMAIL PROTECTED]
Try putting 'error_reporting(E_ALL);' as first line in your script and
see if you get any warnings/notices..
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/32278
--
Edit this bug report at http://bugs.php.net/?id=32278&edit=1
