Shulou(Shulou.com)05/31 Report--

Editor to share with you what to do when you use PB12.6 to operate mysql with SQLSTATE = 37000. I hope you will get something after reading this article. Let's discuss it together.

Pb12.6 + mysql5.7

Appears when querying the database:

Unable to list the users. [Microsoft] [ODBC SQL Server Driver] [SQL Server] cannot predefine statement SQLSTATE = 37000 SQL Server2005

How to handle it:

Add a line to the configuration file my.ini of mysql:

Sql-mode= "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,IGNORE_SPACE"

Then restart mysql

Net stop mysql

Net start mysql

After reading this article, I believe you have a certain understanding of "what to do when using PB12.6 to operate mysql when SQLSTATE = 37000". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.