Cannot connect to my local SQL Server

For whatever reason, I can't connect to my local SQL Server using
TCP/IP from my VB app. If I add Network Library=dbmssocn to the
ConnectionString property, it just won't connect.Says that either the
server doesn't exist or access denied.  If I remove "Network
Library=dbmssocn" from connection string, it will connect fine. This
is very weird, since I have ADO 2.8 installed, which afaik connects via
tcp/ip by default. Neither can I connect to the box (explicitly using
TCP/IP) from other computers, though again, if I don't specify the
network library, the connection is made fine.  I checked the network
settings on the sql server and they seem fine.

Am I missing something simple?

The only odd thing I found is that the name of the server is (LOCAL),
while my PC's name is DEVBOX.  Normally they match.

Thanks
P.S.  This post maybe a duplicate.  The previous one doesn't show up in
my newsreader.

"Frank Rizzo" <nospam@nospam.com> wrote in message
news:eUv3QGOZFHA.584@TK2MSFTNGP15.phx.gbl...
> For whatever reason, I can't connect to my local SQL Server using
> TCP/IP from my VB app. If I add Network Library=dbmssocn to the
> ConnectionString property, it just won't connect.Says that either the
> server doesn't exist or access denied.  If I remove "Network
> Library=dbmssocn" from connection string, it will connect fine.

Then why not do that...?

Bonj wrote:
> "Frank Rizzo" <nospam@nospam.com> wrote in message
> news:eUv3QGOZFHA.584@TK2MSFTNGP15.phx.gbl...
> 
>
> Then why not do that...?

I know the joke, but that wasn't the question.