How to install SQL server 2005 driver for php

From TomatoCMS Documentation

Jump to: navigation, search

TomatoCMS version 2.0.5 supports more than one databases, one of them is SQLServer.

Install SQL Server Driver for PHP

If you want to use SQLServer with php, you have to install SQL Server Driver for PHP.
At here, we will introduce you to install SQL Server Driver for PHP 1.1.
First, download at here
You have to install Microsoft SQL Server Native Client along to SQL Server Driver for PHP, it's required.
With SQL Server Driver for PHP 1.1:

  • Win 32bit, download at here
  • Win 64bit, download at here

After that, install SQL Server Driver for PHP 1.1 into certain folder, you will see many libraries for difference version of php.
Reference following table to select library for your php
File:205_install_sqlsrv_driver_library_table.png

Then, copy it into ext folder of php.
In php.ini file insert following code 

extension = ...

Fill ... as appropriate library which you selected.
The end, let's restart your apache to complete.

Config to run TomatoCMS

Config app.ini file as following to run TomatoCMS 2.0.5 with SQLServer database 

[db]
adapter = "sqlsrv"
prefix = "t_"
slave.server2.host = ".\SQLEXPRESS"
slave.server2.dbname = "tomato_cms"
slave.server2.username = "sa"
slave.server2.password = "123456"
slave.server2.charset = "utf8"
master.server1.host = ".\SQLEXPRESS"
master.server1.dbname = "tomato_cms"
master.server1.username = "sa"
master.server1.password = "123456"
master.server1.charset = "utf8"

Then, run tomatocms\install\tomatocms_sample_db_sqlsrv.sql file to import sample data for SQLServer.
Now, you had a website run with SQLServer database.

Retrieved from "http://docs.tomatocms.com/index.php/How_to_install_SQL_server_2005_driver_for_php"
Personal tools