The app was reporting that it was finishing responses within ms. One headache that has an easier fix than you mentioned is setting the ReturnDatesAsStrings connection setting to 1. Mysterious lag time IIS can exhibit some odd behavior regarding response times. As you know, sqlsrv return dates as DateTime objects and mssql as String. This is more of a CodeIgniter issue. The servers to be used were already in place, and well, it just had to be this way. You may want to try odbc driver built-in db driver in PHP.
|Date Added:||23 February 2014|
|File Size:||48.93 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
I did read about some resolutions regarding DNS settings, and skipping name resolutions in the db configurations. Email Required, but never shown.
I then thought there might be some sort of redirect loop going on. Good to hear from you!
CodeIgniter/PHP + IIS + MySQL + MSSQL: It Works!
Home Forums Search Members Help. Contact Us Return to Top Lite mode. After a trace through the CodeIgniter bootstrap, I found that the application died when the logging class was loaded.
Cara Koneksi Database SQL Server (MSSQL) di Codeigniter 3 – Macamateri
It would be great if you could help me fix this error. Hello, I have recently upgraded to CI 3.
Thank you so much for sharing. That being said, everything worked out much better codeibniter it could have, and there were relatively easy solutions to the bumps along the way. From CodeIgniter, I set the database to use mssql as my driver, and I was home free. Tejas Mehta 9.
php – How to connect Codeigniter with MSSQL (SQL Server)? – Stack Overflow
I should also say this before I start: I would like to say I figured out why IIS was being so lame, but the in-house net-admin suggested moving the application to another production server on hand, where the issue mysteriously dissappeared. A Database Error Occurred Unable to set client connection character set: Subscribe to this thread.
7 Steps to make SQL Server and Codeigniter Works
Mitteg Junior Member Posts: Does anyone have any advice on solving this? Thank god this was so easy. View a Printable Version.
Here is the error I get if I use the sqlsrv driver: Wow-you sure have had some problems! Thread Modes CI 3. Confused, I thought there must be some sort of bottleneck in the application. Instead, you have to ask CodeIgniter to hand codeignuter back the actual database object with each connection.