Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1720
  • Last Modified:

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

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
Leonard Gojer
Asked:
Leonard Gojer
  • 8
  • 6
1 Solution
 
Bob LearnedCommented:
What version of Access are you working with?

What version of Visual Studio.NET are you using?
0
 
Leonard GojerCAD Technician/ProgrammerAuthor Commented:
Access 2003.
Visual Studio 2010 Premier.
0
 
Bob LearnedCommented:
To make sure that I understand what you are referring to, are you talking about the Data > Add New Data Source menu option?
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
Leonard GojerCAD Technician/ProgrammerAuthor Commented:
Yes.
0
 
Leonard GojerCAD Technician/ProgrammerAuthor Commented:
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
 
Bob LearnedCommented:
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
 
Leonard GojerCAD Technician/ProgrammerAuthor Commented:
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
 
Bob LearnedCommented:
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
 
Leonard GojerCAD Technician/ProgrammerAuthor Commented:
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
 
Leonard GojerCAD Technician/ProgrammerAuthor Commented:
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
 
Bob LearnedCommented:
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
 
Leonard GojerCAD Technician/ProgrammerAuthor Commented:
The virtual machine is VMWare running Windows XP.
0
 
Bob LearnedCommented:
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
 
Leonard GojerCAD Technician/ProgrammerAuthor Commented:
I am going to close this question.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 8
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now