SQL Server port, we can set the Server-side Network Trial Tools and "Client Utilities" to set the method:
The default ports in the "Server-side Network Trial" and "Client Utility" and "Client Utility" Settings "->" TCP / IP "->" Properties "->" TCP / IP "-> Properties are assumed to be 1455
Then test if your port is getting up, you can use the Telnet SQL server address 1455 to see if you can telnet, if you can, then you can do the following test.
There is no port number in the past, so it is better to write, but now changed the port number. Many friends are not very clear about how to write the connection statement. The following database connection statement is the form after changing the port:
----------------------------- Set Oconn = Server.createObject ("AdoDb.Connection" Sconn = "driver = {SQL Server}; server = server address, 1455; database = database; uid = username; PWD = password; "Oconn.open sconnresponse.write Oconn ----------------- ----------------
The output is: ------------------------------ provider = msdasql.1; extended Properties = "Driver = SQL Server; Server = server address, 1455; UID = user name; PWD = password; app = Internet information services; wsid = **; database = database "------------------- ------------ This shows that we have successfully connected data!
