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.

Uploader: Zolojora
Date Added: 23 February 2014
File Size: 48.93 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 92740
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!

Hi, Thanks for the great post. I am able to fix this error, Getting the login page but when I click on submit I get this error which is freaking me out: Do something like this: By using our site, you acknowledge that you coeigniter read and understand our Cookie PolicyPrivacy Policyand our Terms of Service.


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.

I was forced to decide between converting the. As you know, sqlsrv return dates as DateTime objects and mssql as String. By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the codeignitwr is subject to these policies.


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.

By Kenny Katzgrau Published: Also, read up on the docs. More info is here: Stack Overflow works best with JavaScript enabled.

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.