A friend called for help to connect to SQL Server from a VFP station and he passed the string to connect to the server.
The string is this:

x = ("DRIVER={SQL Server};SERVER=SERVIDORBANCOS;UID=sa;PWD=obavai;DATABASE=master;Network=DBMSSOCN")
nConnect = SQLSTRINGCONNECT(x)

I dont see nothing wrong here, but it doesn't connect to the server.

I asked him to see what are the protocols used in the Client Network Utility and in the Server Network Utility.
Both have TCP/IP and Named Pipes enabled protocols.

I asked him to just use TCP/IP as a enabled protocol and try to connect again to the server, but it failed.
Then he returned to both protocols.

When I removed the "Network=DBMSSOCN" from the string, the connection was established.
this string to connect works

x = ("DRIVER={SQL Server};SERVER=SERVIDORBANCOS;UID=sa;PWD=obavai;DATABASE=master")
nConnect = SQLSTRINGCONNECT(x)

The question is: Why it works if he removes the network protocol from the connection string?

TIA

Peter