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.

Then why not do that...?

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

VBclassic petition
Class_Terminate problem & Run-time error'424': Object required
determining a rising\falling trend
Package/Deployment
Connection issues with ADO
MkDir with blanks
Creating a Toolbar
3rd Party ActiveX Form Control...
Working application - Now generates error
transparent label