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
Solved

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

Posted on 2012-04-04
14
1,310 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
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
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 

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

The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

Question has a verified solution.

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

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
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…
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…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

840 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