Bug #32278 [Com]: Remote linked server not accessibile
Edit report at https://bugs.php.net/bug.php?id=32278&edit=1
ID: 32278
Comment by: tddy_chandra at yahoo dot com
Reported by:raulionescu at gmail dot com
Summary:Remote linked server not accessibile
Status: No Feedback
Type: Bug
Package:MSSQL related
Operating System: WinXP Pro
PHP Version:5.0.4
Block user comment: N
Private report: N
New Comment:
Thanks, this site really helpful me to get solution call linked server from
php..
:)
Previous Comments:
[2012-02-16 21:23:59] mrezair at azarbod dot com
I used the following and it worked
$result = mssql_query("SET ANSI_NULLS ON") or die(mssql_get_last_message());
$result = mssql_query("SET ANSI_WARNINGS ON") or die(mssql_get_last_message());
$sql_str = "SELECT * FROM OPENQUERY(TEST, 'SELECT I_DESCRIPTION FROM INVFULL')"
;
[2011-03-09 19:42:11] filthy_mcnasty at hotmail dot com
had same problem. glad someone posted a workaround. thanks to the guy who did.
[2011-03-02 01:00:29] michaeljsmalley at gmail dot com
@ericsolan Thank you thank you thank you. Your fix...
$result = mssql_query("SET ANSI_NULLS ON") or die(mssql_get_last_message());
$result = mssql_query("SET ANSI_WARNINGS ON") or die(mssql_get_last_message());
... worked *perfectly* on CentOS release 5.2 (Final) connecting to Microsoft
SQL
Server 9.0.3042.
[2011-03-02 00:55:55] jnovack at gmail dot com
ericsolan at yahoo dot com you are wise behind your years. The workaround
worked
perfectly.
[2009-12-14 20:38:41] ericsolan at yahoo dot com
try adding this right before you call your mssql_query
$result = mssql_query("SET ANSI_NULLS ON") or die(mssql_get_last_message());
$result = mssql_query("SET ANSI_WARNINGS ON") or die(mssql_get_last_message());
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
https://bugs.php.net/bug.php?id=32278
--
Edit this bug report at https://bugs.php.net/bug.php?id=32278&edit=1
Bug #32278 [Com]: Remote linked server not accessibile
Edit report at https://bugs.php.net/bug.php?id=32278&edit=1
ID: 32278
Comment by: mrezair at azarbod dot com
Reported by:raulionescu at gmail dot com
Summary:Remote linked server not accessibile
Status: No Feedback
Type: Bug
Package:MSSQL related
Operating System: WinXP Pro
PHP Version:5.0.4
Block user comment: N
Private report: N
New Comment:
I used the following and it worked
$result = mssql_query("SET ANSI_NULLS ON") or die(mssql_get_last_message());
$result = mssql_query("SET ANSI_WARNINGS ON") or die(mssql_get_last_message());
$sql_str = "SELECT * FROM OPENQUERY(TEST, 'SELECT I_DESCRIPTION FROM INVFULL')"
;
Previous Comments:
[2011-03-09 19:42:11] filthy_mcnasty at hotmail dot com
had same problem. glad someone posted a workaround. thanks to the guy who did.
[2011-03-02 01:00:29] michaeljsmalley at gmail dot com
@ericsolan Thank you thank you thank you. Your fix...
$result = mssql_query("SET ANSI_NULLS ON") or die(mssql_get_last_message());
$result = mssql_query("SET ANSI_WARNINGS ON") or die(mssql_get_last_message());
... worked *perfectly* on CentOS release 5.2 (Final) connecting to Microsoft
SQL
Server 9.0.3042.
[2011-03-02 00:55:55] jnovack at gmail dot com
ericsolan at yahoo dot com you are wise behind your years. The workaround
worked
perfectly.
[2009-12-14 20:38:41] ericsolan at yahoo dot com
try adding this right before you call your mssql_query
$result = mssql_query("SET ANSI_NULLS ON") or die(mssql_get_last_message());
$result = mssql_query("SET ANSI_WARNINGS ON") or die(mssql_get_last_message());
[2009-03-24 20:53:42] ups dot jer at gmail dot com
To provide further info, I just verified that I cannot do this directly, nor
can I call a stored proc which in turn hits the linked server.
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
https://bugs.php.net/bug.php?id=32278
--
Edit this bug report at https://bugs.php.net/bug.php?id=32278&edit=1
Bug #32278 [Com]: Remote linked server not accessibile
Edit report at http://bugs.php.net/bug.php?id=32278&edit=1
ID: 32278
Comment by: filthy_mcnasty at hotmail dot com
Reported by:raulionescu at gmail dot com
Summary:Remote linked server not accessibile
Status: No Feedback
Type: Bug
Package:MSSQL related
Operating System: WinXP Pro
PHP Version:5.0.4
Block user comment: N
Private report: N
New Comment:
had same problem. glad someone posted a workaround. thanks to the guy
who did.
Previous Comments:
[2011-03-02 01:00:29] michaeljsmalley at gmail dot com
@ericsolan Thank you thank you thank you. Your fix...
$result = mssql_query("SET ANSI_NULLS ON") or
die(mssql_get_last_message());
$result = mssql_query("SET ANSI_WARNINGS ON") or
die(mssql_get_last_message());
... worked *perfectly* on CentOS release 5.2 (Final) connecting to
Microsoft SQL
Server 9.0.3042.
[2011-03-02 00:55:55] jnovack at gmail dot com
ericsolan at yahoo dot com you are wise behind your years. The
workaround worked
perfectly.
[2009-12-14 20:38:41] ericsolan at yahoo dot com
try adding this right before you call your mssql_query
$result = mssql_query("SET ANSI_NULLS ON") or
die(mssql_get_last_message());
$result = mssql_query("SET ANSI_WARNINGS ON") or
die(mssql_get_last_message());
[2009-03-24 20:53:42] ups dot jer at gmail dot com
To provide further info, I just verified that I cannot do this directly,
nor can I call a stored proc which in turn hits the linked server.
[2009-03-24 20:51:56] ups dot jer at gmail dot com
Reproduced on PHP Version 5.2.4-2ubuntu5.5
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/bug.php?id=32278
--
Edit this bug report at http://bugs.php.net/bug.php?id=32278&edit=1
Bug #32278 [Com]: Remote linked server not accessibile
Edit report at http://bugs.php.net/bug.php?id=32278&edit=1
ID: 32278
Comment by: michaeljsmalley at gmail dot com
Reported by:raulionescu at gmail dot com
Summary:Remote linked server not accessibile
Status: No Feedback
Type: Bug
Package:MSSQL related
Operating System: WinXP Pro
PHP Version:5.0.4
Block user comment: N
Private report: N
New Comment:
@ericsolan Thank you thank you thank you. Your fix...
$result = mssql_query("SET ANSI_NULLS ON") or
die(mssql_get_last_message());
$result = mssql_query("SET ANSI_WARNINGS ON") or
die(mssql_get_last_message());
... worked *perfectly* on CentOS release 5.2 (Final) connecting to
Microsoft SQL
Server 9.0.3042.
Previous Comments:
[2011-03-02 00:55:55] jnovack at gmail dot com
ericsolan at yahoo dot com you are wise behind your years. The
workaround worked
perfectly.
[2009-12-14 20:38:41] ericsolan at yahoo dot com
try adding this right before you call your mssql_query
$result = mssql_query("SET ANSI_NULLS ON") or
die(mssql_get_last_message());
$result = mssql_query("SET ANSI_WARNINGS ON") or
die(mssql_get_last_message());
[2009-03-24 20:53:42] ups dot jer at gmail dot com
To provide further info, I just verified that I cannot do this directly,
nor can I call a stored proc which in turn hits the linked server.
[2009-03-24 20:51:56] ups dot jer at gmail dot com
Reproduced on PHP Version 5.2.4-2ubuntu5.5
[2009-03-16 14:44:40] mcollard at hotmail dot com
Seconded, this issue is ongoing and problematic.
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/bug.php?id=32278
--
Edit this bug report at http://bugs.php.net/bug.php?id=32278&edit=1
Bug #32278 [Com]: Remote linked server not accessibile
Edit report at http://bugs.php.net/bug.php?id=32278&edit=1
ID: 32278
Comment by: jnovack at gmail dot com
Reported by:raulionescu at gmail dot com
Summary:Remote linked server not accessibile
Status: No Feedback
Type: Bug
Package:MSSQL related
Operating System: WinXP Pro
PHP Version:5.0.4
Block user comment: N
Private report: N
New Comment:
ericsolan at yahoo dot com you are wise behind your years. The
workaround worked
perfectly.
Previous Comments:
[2009-12-14 20:38:41] ericsolan at yahoo dot com
try adding this right before you call your mssql_query
$result = mssql_query("SET ANSI_NULLS ON") or
die(mssql_get_last_message());
$result = mssql_query("SET ANSI_WARNINGS ON") or
die(mssql_get_last_message());
[2009-03-24 20:53:42] ups dot jer at gmail dot com
To provide further info, I just verified that I cannot do this directly,
nor can I call a stored proc which in turn hits the linked server.
[2009-03-24 20:51:56] ups dot jer at gmail dot com
Reproduced on PHP Version 5.2.4-2ubuntu5.5
[2009-03-16 14:44:40] mcollard at hotmail dot com
Seconded, this issue is ongoing and problematic.
[2009-02-19 12:56:46] aromal at gmail dot com
any update on this?
somebody there to give us a reply?
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/bug.php?id=32278
--
Edit this bug report at http://bugs.php.net/bug.php?id=32278&edit=1
#32278 [Com]: Remote linked server not accessibile
ID: 32278
Comment by: ericsolan at yahoo 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:
try adding this right before you call your mssql_query
$result = mssql_query("SET ANSI_NULLS ON") or
die(mssql_get_last_message());
$result = mssql_query("SET ANSI_WARNINGS ON") or
die(mssql_get_last_message());
Previous Comments:
[2009-03-24 20:53:42] ups dot jer at gmail dot com
To provide further info, I just verified that I cannot do this
directly, nor can I call a stored proc which in turn hits the linked
server.
[2009-03-24 20:51:56] ups dot jer at gmail dot com
Reproduced on PHP Version 5.2.4-2ubuntu5.5
[2009-03-16 14:44:40] mcollard at hotmail dot com
Seconded, this issue is ongoing and problematic.
[2009-02-19 12:56:46] aromal at gmail dot com
any update on this?
somebody there to give us a reply?
[2008-07-02 16:35:05] steven_crombie at yahoo dot com
Additional comment to the post above...
To test that there was nothing amiss with the setup, code, or database
server, I changed the query to pull data from a database local to the
SQL Server (not linked database). I got the expected result set.
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
#32278 [Com]: Remote linked server not accessibile
ID: 32278 Comment by: ups dot jer at gmail 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: To provide further info, I just verified that I cannot do this directly, nor can I call a stored proc which in turn hits the linked server. Previous Comments: [2009-03-24 20:51:56] ups dot jer at gmail dot com Reproduced on PHP Version 5.2.4-2ubuntu5.5 [2009-03-16 14:44:40] mcollard at hotmail dot com Seconded, this issue is ongoing and problematic. [2009-02-19 12:56:46] aromal at gmail dot com any update on this? somebody there to give us a reply? [2008-07-02 16:35:05] steven_crombie at yahoo dot com Additional comment to the post above... To test that there was nothing amiss with the setup, code, or database server, I changed the query to pull data from a database local to the SQL Server (not linked database). I got the expected result set. [2008-07-01 21:04:27] steven_crombie at yahoo dot com Web Server: php 5.2.5 Windows 2003 Server Standard SP1 IIS 6.0 SQL Server: SQL Server 2005 Windows 2003 Server Standard SP2 Management Studio 9.00.3042.00 I have not been able to get a result set when using php to query the MS SQL Server when the query references a linked server. I have also tried putting the query in a database view and querying the view instead of directly to the tables. Still no results. I have also tried putting my query in a stored procedure and calling the stored procedure. Still no results returned. All three methods (direct query, view, and stored procedure) produce good results when using Management Studio or the sqlcmd utility. A fix for this long-standing problem would be most appreciated. 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
#32278 [Com]: Remote linked server not accessibile
ID: 32278
Comment by: ups dot jer at gmail 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:
Reproduced on PHP Version 5.2.4-2ubuntu5.5
Previous Comments:
[2009-03-16 14:44:40] mcollard at hotmail dot com
Seconded, this issue is ongoing and problematic.
[2009-02-19 12:56:46] aromal at gmail dot com
any update on this?
somebody there to give us a reply?
[2008-07-02 16:35:05] steven_crombie at yahoo dot com
Additional comment to the post above...
To test that there was nothing amiss with the setup, code, or database
server, I changed the query to pull data from a database local to the
SQL Server (not linked database). I got the expected result set.
[2008-07-01 21:04:27] steven_crombie at yahoo dot com
Web Server:
php 5.2.5
Windows 2003 Server Standard SP1
IIS 6.0
SQL Server:
SQL Server 2005
Windows 2003 Server Standard SP2
Management Studio 9.00.3042.00
I have not been able to get a result set when using php to query the MS
SQL Server when the query references a linked server.
I have also tried putting the query in a database view and querying the
view instead of directly to the tables. Still no results.
I have also tried putting my query in a stored procedure and calling
the stored procedure. Still no results returned.
All three methods (direct query, view, and stored procedure) produce
good results when using Management Studio or the sqlcmd utility.
A fix for this long-standing problem would be most appreciated.
[2008-06-09 20:07:08] cmoore at getzeroedin dot com
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?
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
#32278 [Com]: Remote linked server not accessibile
ID: 32278
Comment by: mcollard at hotmail 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:
Seconded, this issue is ongoing and problematic.
Previous Comments:
[2009-02-19 12:56:46] aromal at gmail dot com
any update on this?
somebody there to give us a reply?
[2008-07-02 16:35:05] steven_crombie at yahoo dot com
Additional comment to the post above...
To test that there was nothing amiss with the setup, code, or database
server, I changed the query to pull data from a database local to the
SQL Server (not linked database). I got the expected result set.
[2008-07-01 21:04:27] steven_crombie at yahoo dot com
Web Server:
php 5.2.5
Windows 2003 Server Standard SP1
IIS 6.0
SQL Server:
SQL Server 2005
Windows 2003 Server Standard SP2
Management Studio 9.00.3042.00
I have not been able to get a result set when using php to query the MS
SQL Server when the query references a linked server.
I have also tried putting the query in a database view and querying the
view instead of directly to the tables. Still no results.
I have also tried putting my query in a stored procedure and calling
the stored procedure. Still no results returned.
All three methods (direct query, view, and stored procedure) produce
good results when using Management Studio or the sqlcmd utility.
A fix for this long-standing problem would be most appreciated.
[2008-06-09 20:07:08] cmoore at getzeroedin dot com
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?
[2008-04-30 16:41:06] webster_jack at hotmail dot com
Hi
Has this bug been fixed?
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
#32278 [Com]: Remote linked server not accessibile
ID: 32278
Comment by: aromal at gmail 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:
any update on this?
somebody there to give us a reply?
Previous Comments:
[2008-07-02 16:35:05] steven_crombie at yahoo dot com
Additional comment to the post above...
To test that there was nothing amiss with the setup, code, or database
server, I changed the query to pull data from a database local to the
SQL Server (not linked database). I got the expected result set.
[2008-07-01 21:04:27] steven_crombie at yahoo dot com
Web Server:
php 5.2.5
Windows 2003 Server Standard SP1
IIS 6.0
SQL Server:
SQL Server 2005
Windows 2003 Server Standard SP2
Management Studio 9.00.3042.00
I have not been able to get a result set when using php to query the MS
SQL Server when the query references a linked server.
I have also tried putting the query in a database view and querying the
view instead of directly to the tables. Still no results.
I have also tried putting my query in a stored procedure and calling
the stored procedure. Still no results returned.
All three methods (direct query, view, and stored procedure) produce
good results when using Management Studio or the sqlcmd utility.
A fix for this long-standing problem would be most appreciated.
[2008-06-09 20:07:08] cmoore at getzeroedin dot com
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?
[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?
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
#32278 [Com]: Remote linked server not accessibile
ID: 32278
Comment by: steven_crombie at yahoo 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:
Additional comment to the post above...
To test that there was nothing amiss with the setup, code, or database
server, I changed the query to pull data from a database local to the
SQL Server (not linked database). I got the expected result set.
Previous Comments:
[2008-07-01 21:04:27] steven_crombie at yahoo dot com
Web Server:
php 5.2.5
Windows 2003 Server Standard SP1
IIS 6.0
SQL Server:
SQL Server 2005
Windows 2003 Server Standard SP2
Management Studio 9.00.3042.00
I have not been able to get a result set when using php to query the MS
SQL Server when the query references a linked server.
I have also tried putting the query in a database view and querying the
view instead of directly to the tables. Still no results.
I have also tried putting my query in a stored procedure and calling
the stored procedure. Still no results returned.
All three methods (direct query, view, and stored procedure) produce
good results when using Management Studio or the sqlcmd utility.
A fix for this long-standing problem would be most appreciated.
[2008-06-09 20:07:08] cmoore at getzeroedin dot com
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?
[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
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
#32278 [Com]: Remote linked server not accessibile
ID: 32278
Comment by: steven_crombie at yahoo 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:
Web Server:
php 5.2.5
Windows 2003 Server Standard SP1
IIS 6.0
SQL Server:
SQL Server 2005
Windows 2003 Server Standard SP2
Management Studio 9.00.3042.00
I have not been able to get a result set when using php to query the MS
SQL Server when the query references a linked server.
I have also tried putting the query in a database view and querying the
view instead of directly to the tables. Still no results.
I have also tried putting my query in a stored procedure and calling
the stored procedure. Still no results returned.
All three methods (direct query, view, and stored procedure) produce
good results when using Management Studio or the sqlcmd utility.
A fix for this long-standing problem would be most appreciated.
Previous Comments:
[2008-06-09 20:07:08] cmoore at getzeroedin dot com
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?
[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".
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
#32278 [Com]: Remote linked server not accessibile
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
#32278 [Com]: Remote linked server not accessibile
ID: 32278 Comment by: webster_jack at hotmail 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: Hi Has this bug been fixed? Previous Comments: [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.. [2005-06-06 11:00:52] raulionescu at gmail dot com I've tried and no changes. Even more, when I tried to execute stored procedures who takes very long time to run (~10-15min), the result is none and my opinion is that seems like a time-out beeing reached because the same stored procedure runs with no problems from SQL querry anliser. 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
#32278 [Com]: Remote linked server not accessibile
ID: 32278 Comment by: kenneth dot kaye at bankofamerica 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: 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? Previous Comments: [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.. [2005-06-06 11:00:52] raulionescu at gmail dot com I've tried and no changes. Even more, when I tried to execute stored procedures who takes very long time to run (~10-15min), the result is none and my opinion is that seems like a time-out beeing reached because the same stored procedure runs with no problems from SQL querry anliser. [2005-04-08 21:26:43] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip 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
#32278 [Com]: Remote linked server not accessibile
ID: 32278 Comment by: redshifteric at gmail 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: 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 Previous Comments: [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.. [2005-06-06 11:00:52] raulionescu at gmail dot com I've tried and no changes. Even more, when I tried to execute stored procedures who takes very long time to run (~10-15min), the result is none and my opinion is that seems like a time-out beeing reached because the same stored procedure runs with no problems from SQL querry anliser. [2005-04-08 21:26:43] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip [2005-04-05 16:44:56] raulionescu at gmail dot com I've tried with PHP 5.0.4 and the problem it's the same 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
