Home > Archive > Visual Basic > May 2005 > Cannot connect to my local SQL Server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Cannot connect to my local SQL Server
|
|
| Frank Rizzo 2005-05-30, 8:55 am |
| 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...?
| |
| Frank Rizzo 2005-05-31, 3:55 pm |
| 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.
|
|
|
|
|