Solved

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

Posted on 2012-04-04
14
1,394 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
[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
  • 8
  • 6
14 Comments
 
LVL 96

Expert Comment

by:Bob Learned
ID: 37811592
What version of Access are you working with?

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

Author Comment

by:Leonard Gojer
ID: 37811617
Access 2003.
Visual Studio 2010 Premier.
0
 
LVL 96

Expert Comment

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

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

Author Comment

by:Leonard Gojer
ID: 37812093
Yes.
0
 

Author Comment

by:Leonard Gojer
ID: 37814656
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
ID: 37815393
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
ID: 37815867
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
 
LVL 96

Expert Comment

by:Bob Learned
ID: 37817138
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
ID: 37817587
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
ID: 37822548
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
ID: 37823037
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
ID: 37823146
The virtual machine is VMWare running Windows XP.
0
 
LVL 96

Accepted Solution

by:
Bob Learned earned 500 total points
ID: 37823162
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
ID: 37823316
I am going to close this question.
0

Featured Post

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

What my article will show is if you ever had to do processing to a listbox without being able to just select all the items in it. My software Visual Studio 2008 crystal report v11 My issue was I wanted to add crystal report to a form and show…
This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
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…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

690 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