Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
qwertyjjj
Posting Yak Master
131 Posts |
Posted - 2008-04-30 : 12:24:50
|
I connect to a spreadshete in the stored procedure. However, when I call the stored proc from my PHP code, I get this:
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. (severity 16) in C:\Inetpub\wwwroot\Finance\kpiImport.php on line 136
Warning: mssql_query() [function.mssql-query]: Query failed in C:\Inetpub\wwwroot\Finance\kpiImport.php on line 136 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.
I have recompiled the sproc with the settings on but it still fails. Any ideas? I do not have this problem with other stored procs called from PHP just this one and its connection to Excel... |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-30 : 21:25:42
|
Tried set those at beginning of the session? |
 |
|
|
|
|