Go Premium for a chance to win a PS4. Enter to Win

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

MFC programming with OLE DB

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
sebide
Asked:
sebide
1 Solution
 
SubramanyaCommented:
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
 
sebideAuthor Commented:
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
 
mrmzxwflCommented:
Try another ODBC DSN
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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