>Bill, adding 'Network=DBMSSOCN' to your connection string will force a TCP/IP connection, instead of the default named pipes.
>
>The syntax would be something like this:
>
>"Server=xyzserver;Database=xyz;Network=DBMSSOCN;UID=johnny;pw=xyzpswd"
>
>This is if you are using FoxPro to programmaticly make the connection. I am not sure if this will work if you are using ADO or something else.
>
>Good luck.
>
>Rob.

Hi Robert,

Thanks for the info. I'll try it out.

In this particular case it is using VB Script ( gasp :-) ) in an Outlook form to access SQL Server data.

Bill