Solved

MFC programming with OLE DB

Posted on 2000-03-08
3
461 Views
Last Modified: 2013-11-25
We tried creating an application in VC++ using MFC Appwizard.
When we tried to select an OLE DB data source in the wizard, we got an error message saying "Data source not accessible" followed by
"Table data not accessible". Can you please tell, what could be the problem.We could however, access OLEDB provider for SQL server when using it for ADODC ActiveX data control. Should we include some options while installing the visual studio?
0
Comment
Question by:sebide
3 Comments
 

Expert Comment

by:Subramanya
ID: 2598346
You have to create the DSN through control panel using odbc data sources
You can use this DSN in the programming
to connect to the database passing
username and passwd,But i never tryed
OLEDB data source directly in the
wizard
0
 

Author Comment

by:sebide
ID: 2599259
Thank you Mr.Subramanya for your immediate response.
We tried creating the ODBC DSN for SQL server and then create OLEDB provider for that ODBC DSN.But, the problem here was that we could select only one table ,that is, multiple selection was not possible. I tried it with CTRL key pressed and Shift key pressed also. Can you help us on this aspect? Please reply soon.
0
 

Accepted Solution

by:
mrmzxwfl earned 25 total points
ID: 2627308
Try another ODBC DSN
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
Have you tried to learn about Unicode, UTF-8, and multibyte text encoding and all the articles are just too "academic" or too technical? This article aims to make the whole topic easy for just about anyone to understand.
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
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…

746 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

12 Experts available now in Live!

Get 1:1 Help Now