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 136Warning: mssql_query() [function.mssql-query]: Query failed in C:\Inetpub\wwwroot\Finance\kpiImport.php on line 136Heterogeneous 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? |
 |
|
|
|
|
|
ansi_NULLS error