Ci Connect To Sql Server

i want to connect to sql server my php version is 5.4 and i have MS SQL Server 2008 R2 and i use PHP Codeigniger 2.1.4 i use sqlsrv30.exe i use XAMPP 1.8.2 i change database.php co

Solution 1:

My mysql had the same problem in the same line and I search a lot for it. It may be your 'port' or 'autoinit'. But mine finally resovled by addressed some problem in server. So check your server is another way.

Solution 2:

Finally figure it out , add die(print_r(sqlsrv_errors(), true)); on DB_driver and read the error log and solve your problem , for me because I just install Native Client 10 and the sqlsrv3.0 require Native Client 11.

Solution 3:

I've had the same trouble you've had about a year ago. Have a look at the replies here, there are some great suggestions from people in there: CodeIgniter MSSQL connection

@StefenWiranata Sorry, just noticed part 2 of your comment - I can't remember where I'd made the change, but I can try and look tonight if you can't get it solved. I know for sure that CI was adding apostrophes around the table names somewhere in system/database/drivers/odbc/, most likely in the odbc_driver.php file.