Solved

How to Add a Data Source in Visual Studio C# Without Errors

Posted on 2012-04-04
14
1,226 Views
Last Modified: 2012-04-09
I am developing a program in Visual Studio C#. I am trying to add a data source to it so
that it can have a database displayed in a DataGrid. When I go to "Add Data Source" and follow the steps, I get the following error: "Could Not Retrieve Schema Information For Table or View". The database is in an .mdb file in the same directory as the program. Can anyone help with this error?
0
Comment
Question by:Leonard Gojer
  • 8
  • 6
14 Comments
 
LVL 96

Expert Comment

by:Bob Learned
Comment Utility
What version of Access are you working with?

What version of Visual Studio.NET are you using?
0
 

Author Comment

by:Leonard Gojer
Comment Utility
Access 2003.
Visual Studio 2010 Premier.
0
 
LVL 96

Expert Comment

by:Bob Learned
Comment Utility
To make sure that I understand what you are referring to, are you talking about the Data > Add New Data Source menu option?
0
 

Author Comment

by:Leonard Gojer
Comment Utility
Yes.
0
 

Author Comment

by:Leonard Gojer
Comment Utility
Hello,
I see that my question has stumped you. I think maybe that I should subscribe to some other service as a way of getting this question answered, because it's kind of an advanced C# question on a relative scale. Can you recommend some service to me that would be such a resource, (perhaps charging under $30/month)?

I am trying to develop this project for a commercial application, but I can't afford a support contract from Microsoft.
0
 
LVL 96

Expert Comment

by:Bob Learned
Comment Utility
I don't work with Access very much, and I have Access 2010.  Also, I don't use the Add Data Sources dialog, so I needed to review.  Sometimes I  get involved in too many questions.  Lastly, I have my own production issues to take care of, which means I can't dedicate all my time.

Did you try the same process with different databases?  Is this a problem with the computer, or the database structure?
0
 

Author Comment

by:Leonard Gojer
Comment Utility
I checked your question and it has the same problem with any database that I create.

I am going to be away from this computer for a couple of days, so you won't have to attend to this problem until sometime like Monday.
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 96

Expert Comment

by:Bob Learned
Comment Utility
Where are the databases that you are trying to connect to with the dialog?  I was assuming local machine, where you should have full rights.  The dialog needs access rights to the target file.

Is this Windows 7, Windows Vista, or Windows 2008 Server?
0
 

Author Comment

by:Leonard Gojer
Comment Utility
I have to try looking into that when I get there, but I am not there right now, so I will
talk to you on Monday. The machine in question is a virtual machine on a server running
Windows XP.
0
 

Author Comment

by:Leonard Gojer
Comment Utility
Hello, I am back from my trip out of town.

I have several books on C#, but I haven't read them thoroughly. It could be that the answer to this question is in one of those books.

I'd like you to help me to understand how I go about looking up this question in one of those books, so that I can be on my own with respect to this problem. Maybe you can give me some "clues" that will get me started to fix it for myself.
0
 
LVL 96

Expert Comment

by:Bob Learned
Comment Utility
That error suggests that you don't have access rights to the database.  The dialog is trying to get information, but doesn't have the necessary security permissions.

What operating system are you working with on your virtual machine?

What are you using for your virtual machine?
0
 

Author Comment

by:Leonard Gojer
Comment Utility
The virtual machine is VMWare running Windows XP.
0
 
LVL 96

Accepted Solution

by:
Bob Learned earned 500 total points
Comment Utility
Windows 7 and Windows Vista have special User Access Control (UAC), that would be a possibility, but Windows XP doesn't have that extra protection.  I don't have any experience with configuring VMWare, so I can't be of any help there.  You would have to ask a different question related to VMWare, if you think that is the cause of your problem.
0
 

Author Comment

by:Leonard Gojer
Comment Utility
I am going to close this question.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

For most people, the WrapPanel seems like a magic when they switch from WinForms to WPF. Most of us will think that the code that is used to write a control like that would be difficult. However, most of the work is done by the WPF engine, and the W…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

728 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

10 Experts available now in Live!

Get 1:1 Help Now