Solved

VS .NET Data connections error

Posted on 2004-03-21
10
256 Views
Last Modified: 2008-02-01
I installed Visual Studio .net 2003, downloaded and installed MSDE 2000 (enabled network protocols). When I try to add a data connection in the server explorer I get this error: "Error
Enumerating Data Servers. Enumerator reports unspecified error".
I thought the problem was related to MDAC and downloaded the "component checker" to reconfigure my MDAC and downloaded the latest one (MDAC 2.8) but it still won't work. Even typing the Server name in the ComboBox does not give me access to my database (pubs)...
Help!
0
Comment
Question by:bakame
  • 4
  • 4
10 Comments
 
LVL 12

Expert Comment

by:dfiala13
ID: 10645141
Did  you install MSDE with the strong password option?

http://support.microsoft.com/default.aspx?scid=kb;en-us;814463
0
 

Author Comment

by:bakame
ID: 10646237
Yes I did, I also allowed network connections and I can access SQL Server using osql from the command prompt.
0
 

Author Comment

by:bakame
ID: 10646286
I reinstalled MSDE and now typing the Server name in the ComboBox DOES give me access to the databases ( I still can't use select from the list)... However, in the process of reinstalling it I lost the "pubs" database and when I try to reinstall with the "SampDBInstall.exe" utility (as I did b4), it gives me an error message to "insure that MSDE IS installled or the current user have sufficient priviledge..."
0
 
LVL 12

Expert Comment

by:dfiala13
ID: 10654953
Hmmm.  

So you can now connect to the database server, but the pubs db is not there.

I am not familiar with SampDBInstall.exe, but are you an administrator on the machine you installed MSDE on?
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:bakame
ID: 10663834
Yes!
0
 
LVL 12

Expert Comment

by:dfiala13
ID: 10664182
I can send you a zipped copy of the pubs database, if you give me an email address or an ftp site.  It's 281 KB.
0
 

Author Comment

by:bakame
ID: 10668455
I installed another instance (NETSDK) of SQL Server (from MSDE) that comes with the pubs DB already installed...
Thanks for your help dfiala13.
0
 
LVL 12

Expert Comment

by:dfiala13
ID: 10668629
Glad you got it working.
0
 

Accepted Solution

by:
PashaMod earned 0 total points
ID: 10698047
Closed, 125 points refunded.
PashaMod
Community Support Moderator
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

A basic question.. “What is the Garbage Collector?” The usual answer given back: “Garbage collector is a background thread run by the CLR for freeing up the memory space used by the objects which are no longer used by the program.” I wondered …
This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now