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, 1242🔥, 0💬
Popular Posts:
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...