Click here to Skip to main content
14,771,107 members
Home » Discussions » Database
   

Database

 
AnswerRe: Database ADO exception on adding new record Pin
CHill6016-Oct-20 6:18
mveCHill6016-Oct-20 6:18 
GeneralRe: Database ADO exception on adding new record Pin
Peter Mortier19-Oct-20 2:58
MemberPeter Mortier19-Oct-20 2:58 
Database is only 126MB big at that stage so this could not be the cause.

I have rewritten the code without datarecord binding :
void WriteToDatabase2(int i)
{
  _RecordsetPtr pRs("ADODB.Recordset");
  HRESULT hr;
  char sql[128];
  sprintf(sql, "insert into TTagData([Value]) values (%d);", i);
  hr=pRs->Open(_variant_t(sql),
    _variant_t((IDispatch*)m_pConnectionPtr, true),
    adOpenStatic, adLockReadOnly, adCmdUnknown);
}

Have written a couple of million of records and now I don't get the exception!
Is there something wrong with the datarecord binding or the way I use it??
AnswerRe: Database ADO exception on adding new record Pin
Peter Mortier19-Oct-20 3:00
MemberPeter Mortier19-Oct-20 3:00 
GeneralRe: Database ADO exception on adding new record Pin
Victor Nijegorodov19-Oct-20 8:07
MemberVictor Nijegorodov19-Oct-20 8:07 
GeneralRe: Database ADO exception on adding new record Pin
Peter Mortier20-Oct-20 9:40
MemberPeter Mortier20-Oct-20 9:40 
GeneralRe: Database ADO exception on adding new record Pin
Victor Nijegorodov20-Oct-20 10:29
MemberVictor Nijegorodov20-Oct-20 10:29 
QuestionDatabase design and custom query for this use case ? Pin
karengsh14-Oct-20 0:17
Memberkarengsh14-Oct-20 0:17 
QuestionShould I store files in a database? Pin
Member 1260015012-Oct-20 23:37
MemberMember 1260015012-Oct-20 23:37 
AnswerRe: Should I store files in a database? Pin
Richard Deeming12-Oct-20 23:54
mveRichard Deeming12-Oct-20 23:54 
QuestionMYSQL Pin
Member 147129666-Oct-20 11:21
MemberMember 147129666-Oct-20 11:21 
AnswerRe: MYSQL Pin
ZurdoDev6-Oct-20 11:34
professionalZurdoDev6-Oct-20 11:34 
QuestionDatabase scripts version control process/strategy? Pin
Member 1363071429-Sep-20 7:06
MemberMember 1363071429-Sep-20 7:06 
AnswerRe: Database scripts version control process/strategy? Pin
David Mujica29-Sep-20 8:48
MemberDavid Mujica29-Sep-20 8:48 
AnswerRe: Database scripts version control process/strategy? Pin
ZurdoDev29-Sep-20 10:05
professionalZurdoDev29-Sep-20 10:05 
QuestionSimple Database design Pin
fdanos23-Sep-20 21:23
professionalfdanos23-Sep-20 21:23 
AnswerRe: Simple Database design Pin
Victor Nijegorodov23-Sep-20 21:54
MemberVictor Nijegorodov23-Sep-20 21:54 
AnswerRe: Simple Database design Pin
Mycroft Holmes24-Sep-20 13:18
professionalMycroft Holmes24-Sep-20 13:18 
QuestionWhy does MySQL not convert dates before 2010-01-01? Pin
fd97507-Sep-20 3:35
professionalfd97507-Sep-20 3:35 
AnswerRe: Why does MySQL not convert dates before 2010-01-01? Pin
Jörgen Andersson7-Sep-20 5:18
professionalJörgen Andersson7-Sep-20 5:18 
GeneralRe: Why does MySQL not convert dates before 2010-01-01? Pin
fd97507-Sep-20 22:14
professionalfd97507-Sep-20 22:14 
AnswerRe: Why does MySQL not convert dates before 2010-01-01? Pin
ZurdoDev21-Sep-20 8:03
professionalZurdoDev21-Sep-20 8:03 
QuestionHow to use a FileInfo control to add a filename to an Access database Pin
rodgerm25-Aug-20 15:51
Memberrodgerm25-Aug-20 15:51 
AnswerRe: How to use a FileInfo control to add a filename to an Access database Pin
Richard MacCutchan25-Aug-20 22:16
mveRichard MacCutchan25-Aug-20 22:16 
QuestionDATABASE KEY Pin
Member 1492238425-Aug-20 1:42
MemberMember 1492238425-Aug-20 1:42 
AnswerRe: DATABASE KEY Pin
OriginalGriff25-Aug-20 1:45
mveOriginalGriff25-Aug-20 1:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.