I have more than 10 databases running under anywhere 12 on windows server 2012, is there any way to connect to any database as client from a pc on the domain without specify port number.
asked 18 Nov '16, 08:56
To connect to a specific database running on your server use the DatabaseName (DBN) connection parameter. Example: To connect to database "MyDatabaseFoo" running on server "myServer" you would use:
Refer to the documentation for more information. HTH
answered 18 Nov '16, 09:00
If you have more than one service you can skip the port, and with more than 2 services you have to do port assignment to optimize the response times of the databases, the way to designate the ports is in the tcpip connection inside the service.
-x tcpip(serverport = 2638)
answered 24 Nov '16, 12:01