Geek Answers Handbook

[Microsoft] [SQL Server Native Client 11.0] Shared memory provider: timeout error [258]

Good afternoon.

I have a site in php5.

All queries are performed using sqlsrv;

When I make a request, I get an error:

[Microsoft][SQL Server Native Client 11.0]Shared Memory Provider: Timeout error [258]

How to fix the error?

+4
source share
3 answers
  • This error is probably caused by a very slow connection or a time-consuming SQL query.
  • This is not a SQL Server issue.

  • Try increasing the timeout value in your connection string in PHP.

    See previous answer

You need to change some settings in php.ini: upload_max_filesize = 2M or whatever size you want

max_execution_time = 60; also above if you should

If your PHP.ini depends on your environment

+2
source

Setting max_execution_time to 0 (without restrictions) alone did not do this for me.

However, the default memory limit has increased from 128MB to 2GB :

 max_execution_time = 0 memory_limit = 2048M
0
source

PHP 5.3.19 to Sql Server 2008 all requests, including "select getdate ()", Changing the two parameters max_execution_time to 0 and memory_limit = 1024M did this for me.

0
source

More articles:


All Articles