>Hi:
>
>Can anyone give me an example of an ODBC connect string that can be used with SQLSTRCONNECT() that includes a port number and protocol?
>
>I been using the default SQL Server port of 1433, but the network people are telling me ports 1353 - 1502 will be blocked so I'll have to reconfigure SQL Server to listen on some other port. Also, do I have to wait for them to assign me a new port or can I just pick one? I'm a little confused over the port assignments. How do they get assigned?
>
>Thanx,
>Charlie
Charlie,
Check out MSKB#
Q287932. It may be of help.
As for configuring the conenction string, add the following to it:
network=dbmssocn;address=MyIPAddressHere,MyPortNumberHere
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao