• 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Error Database Connection

#1
Currently I'm developing a project using:
  • PHP Framework CodeIgniter (V.2..)
  • Database SQL Server 2018
Actually this is my old project. As usual it runs well, but sometimes if I refresh it many times or there are about 10 users accessing it in real time, suddenly I get error although my database setting is correct. The error says:
--------------------------------------------------------------------------------------------------------
A Database Error Occurred
Unable to connect to your database server using the provided settings.
Filename: E:\wamp\www\dev_Clin4\framework\system\database\DB_driver.php
Line Number: 125
-----------------------------------------------------------------------------------------------------------
I use XAMPP version 2.5.8 as my local server and SQL Server as the database. I'm just curious, it's a framework issue; can't handle a huge database so the database server disconnected it automatically, perhaps the query is not effective, bad scripting or maybe...

Maybe anyone can share the experiences due to this issue or solution?
Thank you
Reply

#2
I suggest looking into the number of connections your instance of SQL server allows and/or maybe available memory for the database. Checking the SQL Server logs may provide some ideas on other areas to investigate too. I don't think it's the framework though it might be the use of persistent connections. (?)
Reply

#3
You should check database credenticals, and then check error log for more information Wink
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.