>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
The following works, but this is for when you know the port number:
"Driver=SQL Server;Network=DBMSSOCN;Address=myServer,1433;Database=myDB; Trusted_Connection=Yes;Server=myServer"
Also I believe that the normal DSN-less connection defaults to dynamically look for a port. Create a test DSN and click on the "Client Configuration" button on one of the wizard steps to see this setting. You might want to test your usual connection without any changes to see if that works. HTH