The 'Network=DBMSSOCN' forces TCP/IP protocol to be used for connection. When SQLSTRINGCONNECT(0 fails you should use AERROR() function to get detailed info about ODBC error.

>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