Php connection with Sql Server

[Farhad.idrees]

Hi i just want to know that how to connect php with sql server..because i have database in my sql server....
regards..
Farhad

[cereal]

http://www.php.net/manual/en/refs.database.php

Happy reading.

[cwarn23]

<?php
$user='cwarn23';
$password='password';
$database_name='cwarn_phpbb';
mysql_connect('localhost',$user,$password);
mysql_select_db($database_name);

[Farhad.idrees]

<?php
$user='cwarn23';
$password='password';
$database_name='cwarn_phpbb';
mysql_connect('localhost',$user,$password);
mysql_select_db($database_name);

My dear i want to connect with Sql server not with Mysql...

[cwarn23]

My dear i want to connect with Sql server not with Mysql...

In that case replace localhost with the ip of the sql server's ip address and on the sql server admin panel allow remote sql then you should be able to perform remote sql tasks. If you need a hand enabling remote sql on your sql server then please describe what control panel you use, what php version your using and mysql version.

[Stefano Mtangoo]

http://php.net/manual/en/book.mssql.php
http://www.microsoft.com/download/en/details.aspx?id=8887
http://php.net/manual/en/ref.pdo-dblib.php

[arajapandi]

Hi Farhad,

Try with mssql_connect functions.

OR

If your server doen't have mssql installed then try with odbc connection...

Steps to use odbc
Goto control panel -> Administrative tools -> Data Sources (ODBC)-> click system DSN -> Create DSN for SQL Server

You can connect SQL server using the below functions ...
$conn = odbc_connect('System dsn name created using ODBC','usernmae', 'password');
$res = odbc_exec($conn,"SELECT * from ajaxmint");