解决php连接mssql时遇到的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问题
2023-05-16
SqlServer
548
0
PHP使用sqlserver数据库连接外部数据库出现以下错误: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报这个错误,只需要在连接mssql数据库成功之后加入以下代码即可。mssql_query("SET ANSI_NULLS ON");
mssql_query("SET ANSI_WARNINGS ON");