Collections:
mssql_connect() - Connecting to Different Port Numbers
How To Connect with Different Port Numbers?
✍: Guest
You 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('LOCALHOST\SQLEXPRESS','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:
<?php print("Calling 'LOCALHOST'\n"); mssql_connect('LOCALHOST','sa','FYIcenter'); print("Calling 'LOCALHOST\SQLEXPRESS'\n"); mssql_connect('LOCALHOST\SQLEXPRESS','sa','FYIcenter'); print("Calling 'LOCALHOST,1269'\n"); mssql_connect('LOCALHOST,1269','sa','FYIcenter'); print("Calling 'LOCALHOST,SQLEXPRESS'\n"); mssql_connect('LOCALHOST,SQLEXPRESS','sa','FYIcenter'); print("Calling 'LOCALHOST:SQLEXPRESS'\n"); mssql_connect('LOCALHOST:SQLEXPRESS','sa','FYIcenter'); print("Calling 'LOCALHOST:1269'\n"); mssql_connect('LOCALHOST:1269','sa','FYIcenter'); ?>
You will get:
Calling 'LOCALHOST' Calling 'LOCALHOST\SQLEXPRESS' 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: LOCALHOST:SQLEXPRESS Calling 'LOCALHOST:1269' Warning: mssql_connect(): Unable to connect to server: LOCALHOST:1269
⇒ Commonly Used MSSQL Functions in PHP
⇐ Finding ntwdblib.dll Version 2000.80.194.0
⇑ SQL Server FAQs - PHP MSSQL Functions - Connections and Query Execution
2024-04-14, 1357🔥, 0💬
Popular Posts:
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...