RE: SQL Server does not exist error

From: DavidN (davidn_at_brokentrain.com)
Date: 08/27/04 

Date: Fri, 27 Aug 2004 05:37:26 -0700

Kevin,

Problem solved. I think there is a bug in Visual Studio.
On the Data Link Properties panel, Connect tab, Line 1
states Select or enter server name. On my machine this
box was empty and and page 229 of the book "Developing web
applications with Microsoft Visual Basic.NET and Visual
C#.NET, second edition" the example does not specify
entering any thing on this line and shows an example with
this box empty. The test connection button at the bottom
of the tab will return 'test succeeded' with this,
however, this only implies that Visual Studio can find the
server, probably through some default method. The data
adapter must be trying to find the server some other way,
and I am guessing it is relying on a list built by Visual
Studio for Line 1. Since I installed the desktop server
AFTER Visual Studio, this list is empty. There is
a 'refresh' button next to line 1 which I would assume
means refresh the list of servers, however, when I push
the button, I get the message 'Error enumerating data
servers, enumerator reports unspecified error'. If I type
my server name into box then push the button I still get
the same message. This is where I discovered the solution
to my problem. If I type my server name in on line 1 and
do not push refresh, the data link will be made properly.
I am guessing here, but I think there is a bug in the
refresh button possibly because I used
DISABLENETWORKPROTOCOLS=1 on my install. Maybe it is
trying to use TCP/IP to find the server. Maybe if I
reinstalled Visual Studio (which I am not going to do)
this list would be fine. Anyway, I'm moving on.

Thanks for your help.
David

>-----Original Message-----
>What happens if you specify (local) for the servername in
the connection
>string?
>
>Thanks,
>
>Kevin McDonnell
>Microsoft Corporation
>
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>
>
>.
>

Quantcast