ADO ...

[HadiRezaee]

Hi all,
My source code won't work, what is my wrong ?
My database is Access 2000.


pApp->pConnection->Open(_bstr_t("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Server.mdb;&quot, _bstr_t("&quot, _bstr_t("&quot, adConnectUnspecified);

pApp->pRecordsetACTION->Open(_variant_t(_bstr_t("SELECT * FROM ACTION&quot), pApp->pConnection.GetInterfacePtr(), adOpenDynamic, adLockOptimistic, adCmdText);

Help me !!!

 

[Cagliostro]

is there some Run method? If so, use it instead of Open when working with queries. Ion Filipski

filipski@excite.com

 

[128334]

Take a look at this code:

CoInitialize(NULL);
_ConnectionPtr m_pConn;
m_pConn.CreateInstance(__uuidof(Connection));
m_pConn->Open(_bstr_t("Provider=MSDASQL.1;Persist Security Info=False;Data Source=Probe&quot,_bstr_t("&quot,_bstr_t("&quot,adConnectUnspecified);

_CommandPtr pCommand;
pCommand.CreateInstance (__uuidof (Command));
pCommand->ActiveConnection = m_pConn;
pCommand->CommandText = "Select * From Zone";

_RecordsetPtr pRecordset;
pRecordset.CreateInstance (__uuidof (Recordset));
pRecordset->CursorLocation = adUseClient;
pRecordset->Open ( (IDispatch *) pCommand, vtMissing, adOpenStatic, adLockBatchOptimistic, adCmdUnknown);

 

[HadiRezaee]

Thanks 128334, Your sample was useful ...
Other question ...

I'm writing Client & Server program, i'm using ADO ...

If i wanna write program on the Client computer, i must add this line to my source code ?

pRecordset->CursorLocation = adUseClient;

Is that necessery ?