Database connectivity to visual c++

[cheeky]

Can u tell me how to connect MS:visual c++ (version 6) fields to an access database using dao odbc and how to add, delete and modify records from a table.

an explanation in detail will be appreciated.

 

[IonelBurtan]

Look at the FAQ section - I think there is one FAQ on these theme s-)

Blessed is he who in the name of justice and good will, shepards the week through the valley of darkness...

http://www20.brinkster.com/ionelb

 

[JasonDBurke]

not exactly sure if this is what your looking for. What I think you need to do is set up a DB provider and consumer model. To first make the provider you need to open up a new database project and fill out the info for the driver to be created. Then you have the choice of buiding a consumer app through the wizards provided (MFC AppWizard.exe) or Insert->ATL object -> data access -> consumer. Either way a header will be generated for you. #include the header onto your .cpp and make an instance of the class (not the accessor class) and just do myclass.Open(). This should open a connection and then you should beable to do things like MoveNext and Insert and all that fancy stuff.

 

[HadiRezaee]

Insert->ATL object -> data access -> consumer is for using of ADO ATL, it is not DAO connection ...

 

[Cagliostro]

This is a short sample using ADO.

#include <iostream>
#include <fstream>
#include <string>
#include <ctype.h>
#include<atlbase.h>
#include<adoint.h>
using namespace std;
int main(int argc, char* argv[])
{
CoInitialize(0);
{
CComPtr<_Connection> pConn;
CComPtr<IUnknown> pUnk;
HRESULT hr=pConn.CoCreateInstance(L&quot;ADODB.Connection&quot;,0,CLSCTX_INPROC_SERVER);
if(FAILED(hr))
{
cout<<&quot;failed&quot;<<endl;
}
hr=pConn->Open(SysAllocString(L&quot;driver={Microsof Access Driver (*mdb)};database={Path:\...\YourDB.mdb};&quot,
SysAllocString(L&quot;&quot,SysAllocString(L&quot;&quot,0);
if(FAILED(hr))
{
cout<<&quot;failed&quot;<<endl;
}
hr=pConn->Execute(SysAllocString(L&quot;create table SomeTable(a int,b char(1))&quot,0,0,0);
if(FAILED(hr))
{
cout<<&quot;failed&quot;<<endl;
}
}
CoUninitialize();
return 0;
}
John Fill

ivfmd@mail.md

 

[jtm111]

I think you also need to import the ado driver in MS VC++, after the includes at the top of the implementation file put:

#import &quot;c:\program files\common files\system\ado\msado15.dll&quot; rename (&quot;EOF&quot;,&quot;adoEOF&quot no_namespace

If it doesn't work, check the path of msado15.dll and edit to suit you.

 

[Cagliostro]

LOL jtm11, you shouldn't. Try it yourself and see. John Fill

ivfmd@mail.md

 

[HadiRezaee]

All of you wrote example about ADO, but cheeky need help with DAO ...

 

[Cagliostro]

is too few differences. MFC DAO and ADO wrappers are the same. And MFC ODBC wrapper also is the same. Maybe some small differences in the class names (one-two letters, no more) John Fill

ivfmd@mail.md