How To Connect PHP with Different Port Numbers?
Submitted by: AdministratorYou know that SQL Server could be configured to accept connections with different TCP/IP port numbers. See other tutorial collections on how to view and configure SQL Server TCP/IP protocol.
If you installed SQL Server 2005 Express Edition with default settings, it should be running with instance name of "SQLEXPRESS" and port number of "1269" You can use the mssql_connect() function to connect to the server in 3 ways:
$con = mssql_connect('LOCALHOST','login','pass');
$con = mssql_connect('LOCALHOSTSQLEXPRESS','login','pass');
$con = mssql_connect('LOCALHOST,1269','login','pass');
Other ways of entering the server name and port number will not work. The PHP manual has this statement: "servername - The MS SQL server. It can also include a port number. e.g. hostname:port." The example is really for non-Windows systems. Try the following testing PHP script to find out:
Submitted by: Administrator
If you installed SQL Server 2005 Express Edition with default settings, it should be running with instance name of "SQLEXPRESS" and port number of "1269" You can use the mssql_connect() function to connect to the server in 3 ways:
$con = mssql_connect('LOCALHOST','login','pass');
$con = mssql_connect('LOCALHOSTSQLEXPRESS','login','pass');
$con = mssql_connect('LOCALHOST,1269','login','pass');
Other ways of entering the server name and port number will not work. The PHP manual has this statement: "servername - The MS SQL server. It can also include a port number. e.g. hostname:port." The example is really for non-Windows systems. Try the following testing PHP script to find out:
Submitted by: Administrator
<?php
print("Calling 'LOCALHOST' ");
mssql_connect('LOCALHOST','sa','GlobalGuideLine');
print("Calling 'LOCALHOSTSQLEXPRESS' ");
mssql_connect('LOCALHOSTSQLEXPRESS','sa','GlobalGuideLine');
print("Calling 'LOCALHOST,1269' ");
mssql_connect('LOCALHOST,1269','sa','GlobalGuideLine');
print("Calling 'LOCALHOST,SQLEXPRESS' ");
mssql_connect('LOCALHOST,SQLEXPRESS','sa','GlobalGuideLine');
print("Calling 'LOCALHOST:SQLEXPRESS' ");
mssql_connect('LOCALHOST:SQLEXPRESS','sa','GlobalGuideLine');
print("Calling 'LOCALHOST:1269' ");
mssql_connect('LOCALHOST:1269','sa','GlobalGuideLine');
?>
You will get:
Calling 'LOCALHOST'
Calling 'LOCALHOSTSQLEXPRESS'
Calling 'LOCALHOST,1269'
Calling 'LOCALHOST,SQLEXPRESS'
Warning: mssql_connect(): Unable to connect to server:
LOCALHOST,SQLEXPRESS
Calling 'LOCALHOST:SQLEXPRESS'
Warning: mssql_connect(): Unable to connect to server:
Submitted by: Administrator
print("Calling 'LOCALHOST' ");
mssql_connect('LOCALHOST','sa','GlobalGuideLine');
print("Calling 'LOCALHOSTSQLEXPRESS' ");
mssql_connect('LOCALHOSTSQLEXPRESS','sa','GlobalGuideLine');
print("Calling 'LOCALHOST,1269' ");
mssql_connect('LOCALHOST,1269','sa','GlobalGuideLine');
print("Calling 'LOCALHOST,SQLEXPRESS' ");
mssql_connect('LOCALHOST,SQLEXPRESS','sa','GlobalGuideLine');
print("Calling 'LOCALHOST:SQLEXPRESS' ");
mssql_connect('LOCALHOST:SQLEXPRESS','sa','GlobalGuideLine');
print("Calling 'LOCALHOST:1269' ");
mssql_connect('LOCALHOST:1269','sa','GlobalGuideLine');
?>
You will get:
Calling 'LOCALHOST'
Calling 'LOCALHOSTSQLEXPRESS'
Calling 'LOCALHOST,1269'
Calling 'LOCALHOST,SQLEXPRESS'
Warning: mssql_connect(): Unable to connect to server:
LOCALHOST,SQLEXPRESS
Calling 'LOCALHOST:SQLEXPRESS'
Warning: mssql_connect(): Unable to connect to server:
Submitted by: Administrator
Read Online MS SQL Server Job Interview Questions And Answers
Top MS SQL Server Questions
☺ | What Happens If NULL Values Are Involved in Bitwise Operations? |
☺ | What Happens If You Insert a Duplicate Key for the Primary Key Column in MS SQL Server? |
☺ | How To Find Out What Is the Default Collation in a Database? |
☺ | Does Index Slows Down INSERT Statements? |
☺ | What are system databases in MS SQL Server? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |