"Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=myUsername;Password=myPassword;" Network protocol codes
| Name | Network library |
|---|---|
| dbnmpntw | Named Pipes |
| dbmslpcn | Shared Memory (local machine connections only, might fail when moving to production...) |
| dbmssocn | Winsock TCP/IP |
| dbmsspxn | SPX/IPX |
| dbmsvinn | Banyan Vines |
| dbmsrpcn | Multi-Protocol (Windows RPC) |
| dbmsadsn | Apple Talk |
| dbmsgnet | VIA |
Important note
When connecting through the SQLOLEDB provider use the syntax "Network Library=dbmssocn" and
when connecting through the MSDASQL provider use the syntax "Network=dbmssocn".
