Originally posted by: Kirk Stowell
Nice job on the Interactive SQL Tool (using ADO)!
ReplyOriginally posted by: Victor Vuick
I have a problem when compiling ChildFrm.cpp ; the error is
error C2653: 'ADODB' : is not a class or namespace name.
Have I to pass to service pack 3, probably ?
Thanks,
Victor
Originally posted by: Anonymous
Not truely a DBPROP_ROWSET_ASYNCH type of data access. See RowsetViewer.exe for more information.
Reply
Originally posted by: Sammy
I think my explanation is quite poor, I will show my code here:
_variant_t vNull;
bstrQuery = _bstr_t("SELECT * FROM Appointment");
I can use the m_pAppRec.AddNew(...) to add a tuple of record, but while I type m_pAppRec->GetRecordCount(), it returns -1 to me. How to solve this?
Thank you very much!
I got a proj.mdb file, I open a recordset called "AppRec" to retrieve information of table "Appointment" in proj.mdb. I can AddNew record to that table. But I cannot get the record .
vNull.vt = VT_ERROR;
vNull.scode = DISP_E_PARAMNOTFOUND;
_bstr_t bstrQuery;
hr = m_pAppRec.CreateInstance(__uuidof(Recordset));
if (SUCCEEDED(hr))
{
m_pAppRec->PutRefActiveConnection(((CProjApp*)
AfxGetApp())->m_pConnection);
hr = m_pAppRec->Open(_variant_t(bstrQuery), vNull,
adOpenDynamic, adLockOptimistic, adCmdText);
}
Originally posted by: Chris Adams
Hi there,
This example was exactly what I was looking for. I downloaded the update and noticed that is it screamingly faster than the original. Is this related to the different handling of the "grid control", or due to some code change with the database interaction? The original app ran a query in 41 seconds, but the new one shaved that down to 10.
I was curious if the source for the new application will be available?
Thanks so much for this app!
Chris
Originally posted by: George Poulose
Can be found at:
http://home.att.net/~gpoulose/
George
ReplyOriginally posted by: Ali Reza Haji Hosseini
Prefect sample ! NICE work
ReplyOriginally posted by:
Vinod
Hai,
It's fine. When I am building this i am getting the following errors. I think this is the version problem when i am going through MSDN help, i got that it is a bug of MS and I got the resoulution as follows::
1.Install Visual Studio, Service Pack 3.
2.Upgrade to Visual C++, version 6.0.
3.Modify the resultant .tlh file by moving each of the declarations for
_Connection15, _Recordset15, Field15
ahead of each of the declarations for:
Connection, Recordset , and Field
Encountered Error types::
error C2504: '_Connection15' : base class undefined
error C2504: '_Recordset15' : base class undefined
error C2504: 'Fields15' : base class undefined
error C2664: '_com_issue_errorex' : cannot convert parameter 2 from 'struct ADODB::_Connection *const ' to 'struct IUnknown *'
Can you give me any other resolution for this problem, Please! Can we use any other objects instead of _Connection15,_Recordset15,Fields15. Presently I am using VC++ 5.0 Version.
Thanks a lot,
Naga vinod.
nagavinod@yahoo.com
Reply
Originally posted by: Chieu Luu
Hi George,
When I try to compile your project, I got this error:
Can not open file "adoint.h", I search around in that directory, I could not find it. May you please send that file to me, I am very appreciated.
ReplyOriginally posted by: Tom
There is Picture storeing (Type is image)in SQL server database,
I want to get and data, I used
_variant_t vt=field->getChunk(field->ActualSize);
But I couldn't get (unsigned char *) data correctly!
I don't known how to create a _variant_t for useing AppendChunk(..),
I have uesd VC++ extention:
ADO_VARIABLE_LENGTH_ENTRY2(4,adLongVarBinary,m_szname1,sizeof(m_szname1),name_state1,TRUE)
It could get data ,But it can't write corretly!
How to get and put image data? Can you tell me?
Thanks!
Tom
wugangmail@btamail.net.cn
