CodeIgniter MSSQL connection

by

For x86 win download http://www.microsoft.com/en-us/download/details.aspx?id=20098 for using with:

$db['default']['dbdriver'] = 'sqlsrv';
use the php_sqlsrv_XX_ts_vcX.dll in php.ini extension

if your webserver and your database server are not on same server with your app, install this:

http://go.microsoft.com/fwlink/?LinkID=188400&clcid=0x409

and for linux as webserver:

$db[‘default’][‘dbdriver’] = ‘mssql’;

download & install = php5-sybase + freetds
<br/>edit /usr/local/etc/freetds.conf
<br/>create pdo_dblib.so & php_mssql.so (if not allready exist on your extension dir), and apply to php.ini

sudo /etc/init.d/apache2 restart

and just dont forget to allow connection to your DB (default port for mssql is 1433)

More Related Contents:

  1. Connect PHP to MSSQL via PDO ODBC
  2. How can I detect a create, update, delete query is successful in Codeigniter
  3. How to print SQL statement in codeigniter model
  4. Fatal error: Call to undefined function sqlsrv_connect() in C:\xampp\htdocs
  5. How to use PHP to connect to sql server
  6. How to execute my SQL query in CodeIgniter
  7. Linux – PHP 7.0 and MSSQL (Microsoft SQL)
  8. Get Return Value from SQL Stored Procedure using PHP
  9. How to make search query like Youtube? [closed]
  10. how to use json_encode for my output?
  11. check if link “still” exists [duplicate]
  12. CodeIgniter – foreach loop
  13. How to use query string in Codeigniter?
  14. Getting raw SQL query string from PDO prepared statements
  15. MySQL Prepared statements with a variable size variable list
  16. How to load a controller from another controller in codeigniter?
  17. How to replace MySQL functions with PDO?
  18. CodeIgniter: Create new helper?
  19. CodeIgniter htaccess and URL rewrite issues
  20. Connect to SQL Server through PDO using SQL Server Driver
  21. Uploading in Codeigniter – The filetype you are attempting to upload is not allowed
  22. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  23. How to integrate WordPress template with CodeIgniter
  24. CodeIgniter activerecord, retrieve last insert id?
  25. How to set cron job URL for CodeIgniter?
  26. Codeigniter assets folder best practice
  27. How to stop GD2 from washing away the colors upon resizing images?
  28. Do I have to use mysql_real_escape_string if I bind parameters?
  29. PDO and MySQL ‘between’
  30. How can I have CodeIgniter load specific pages using SSL?

Leave a Comment