Is there an easy error free way to connect to a MS Access database using C++ and ADO/OLEDB? Using VC++2005

[Imaginer]

There is not any one good way I found or solution out there that works flawlessly. Any suggestions?

 

[joshg]

I guess I don't understand what kind of problems you are having... So you are connecting through OLE provider and passing the file name as part of your connection string?

Honestly I can't say I've ever really had problems this way or using ODBC system DSN or even file DSN... once you get your connection string / provider string exactly the way it needs to be everything just kind of "works" (albeit in an Access sort of way of course... 😉 )

 

[Imaginer]

Say in Visual C++, I want some set of data to appear based on what is immediately selected via a dropdown box. Is there any equivalent way to do this? The result would appear below the dropdown box.

In axp, this is easily doable but with windows and its forms and controls, I am stumped on how to do this.

In a class that I have created and upon this class this will execute.



I KNOW this is NOT the correct way of doing things here but I am coming from a classic asp mindset where if a user does this, I get the data the user selects, run a query and do whatever via recordsets. Help me out here. 🙁

 

[Imaginer]

Oh and I am also getting the data via the Data wizard with Visual 2005 and it has generated an overall .xsd file

 

[Imaginer]

Ok, i figured out the data wizard in C++ 2005 and it was able to generate a DataAdapter and a TableAdapter and I am able to pass any query I want with it. Problem is, how do I pass a value from what a user selects in a form control and push it into a query and pull the results back out in 2005? I am not sure of the structure they have here.

If any good examples are out there, I would appreciate it since I am unable to find any using searches as Visual C++ 2005, DataAdapter, OLE, ADO, TableAdapter, etc.