• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
CI and MS SQL how to connect ?

#2
[eluser]timpisti[/eluser]
Hi (sorry for bad english).

MS-SQL (MS) and PHP (Mostly Linux) using in same time is always a difficult thing.

First: Over 4-6 month of searching, I can't find a working solution to connect the MSSQL database with Windows autentication on PHP. There is some setting in php.ini at MSSQL part, but it's not seems to be working. It's not the CI problem, the mssql.connect function throw an error.

Second: You may create an SQL user for PHP to connect a database. Bad point: You'll miss the windows authentication. Good: Commonly used for everywhere, with a very little security risk.

Third: You may use ODBC connection. The CI work properly with that.

Good luck.


Messages In This Thread
CI and MS SQL how to connect ? - by El Forum - 12-15-2009, 02:57 AM
CI and MS SQL how to connect ? - by El Forum - 12-15-2009, 06:04 AM
CI and MS SQL how to connect ? - by El Forum - 12-15-2009, 01:00 PM
CI and MS SQL how to connect ? - by El Forum - 12-16-2009, 10:04 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


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