Connecting to MS SQL from php

PHP
1

I am trying to connect to an MS SQL database using the following PHP code:


$hostname_conn_iShore = "213.171.201.131";
$database_conn_iShore = "database_name";
$username_conn_iShore = "username";
$password_conn_iShore = "password";
$conn_iShore = mssql_connect($hostname_conn_iShore, $username_conn_iShore, $password_conn_iShore);

However, I am getting an Internal Server Error (500).

Any ideas why?

2

500 means there was a PHP error. Can you post that error form your logs?

It is likely that you gave 3 params instead of 4 (you missed the DB name)

Also, putting “_iShore” at the end of var names is something I bet you will regret. Why not simply do:


$db_con = mssql_connect("213.171.201.131", "database_name", "username", "password");
3

Tried adding the database name but got same error. Also, I cant post error logs as this is on a shared server.

4

Please refer - http://php.net/manual/en/function.mssql-connect.php

i think you don’t have to provide database name as the syntax say

resource mssql_connect ([ string $servername [, string $username [, string $password [, bool $new_link ]]]] )

Regards