dynamic port connection

Hi,
What is your question?
Sincerely,
Invotion Engineering Team
Advanced Microsoft Hosting Solutions
http://www.Invotion.com
>--Original Message--
>We have a customer who uses the dynamic port assignment
option when a connection is established, instead of the
default 1433. However, our application requires a fixed
port number, either the default 1433 or an explicitly set
port number.
>For now we are accessing this small database via the
ODBC connector using the Microsoft-supplied ODBC for
SQLServer driver. However, this is not a solution for
larger databases because of the additional overhead
involved.
>Any assistance will be very appreciated.
>Alex Ivascu
>(posted to server ng, by mistake)
>.
>This particular database server has multiple instances, and one of them is t
he one that we need to connect to. How do we know what port number to conne
ct to, with our application? Since the only things that we can specify in o
ur connector is a port numb
er and a server name...
Thanks.|||If the application is an ODBC application using MDAC 2.6 or greater, we'll
enumerate the ports and connect on the right one.
If you don't want that behavior, then set the ports to a fixed port and use
this in your connection string.
823938 How to use static and dynamic port allocation in SQL Server 2000
http://support.microsoft.com/?id=823938
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.