Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

VS .NET Data connections error

Posted on 2004-03-21
10
Medium Priority
?
273 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
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
 

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

609 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