>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.