Click here to Skip to main content
15,071,137 members
Home / Discussions / Database
   

Database

 
AnswerRe: The Best Free Database for real-time data storing and querying Pin
Mycroft Holmes28-Oct-20 12:07
professionalMycroft Holmes28-Oct-20 12:07 
GeneralRe: The Best Free Database for real-time data storing and querying Pin
Member 1332584629-Oct-20 18:56
MemberMember 1332584629-Oct-20 18:56 
AnswerRe: The Best Free Database for real-time data storing and querying Pin
Gerry Schmitz30-Oct-20 8:40
mveGerry Schmitz30-Oct-20 8:40 
AnswerRe: The Best Free Database for real-time data storing and querying Pin
Eddy Vluggen26-Jan-21 12:36
professionalEddy Vluggen26-Jan-21 12:36 
QuestionDatabase ADO exception on adding new record Pin
Peter Mortier16-Oct-20 4:21
MemberPeter Mortier16-Oct-20 4:21 
GeneralRe: Database ADO exception on adding new record Pin
Richard MacCutchan16-Oct-20 4:53
mveRichard MacCutchan16-Oct-20 4:53 
AnswerRe: Database ADO exception on adding new record Pin
CHill6016-Oct-20 5:18
mveCHill6016-Oct-20 5:18 
GeneralRe: Database ADO exception on adding new record Pin
Peter Mortier19-Oct-20 1:58
MemberPeter Mortier19-Oct-20 1: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 2:00
MemberPeter Mortier19-Oct-20 2:00 
GeneralRe: Database ADO exception on adding new record Pin
Victor Nijegorodov19-Oct-20 7:07
MemberVictor Nijegorodov19-Oct-20 7:07 
GeneralRe: Database ADO exception on adding new record Pin
Peter Mortier20-Oct-20 8:40
MemberPeter Mortier20-Oct-20 8:40 
GeneralRe: Database ADO exception on adding new record Pin
Victor Nijegorodov20-Oct-20 9:29
MemberVictor Nijegorodov20-Oct-20 9:29 
QuestionDatabase design and custom query for this use case ? Pin
karengsh13-Oct-20 23:17
Memberkarengsh13-Oct-20 23:17 
QuestionShould I store files in a database? Pin
Member 1260015012-Oct-20 22:37
MemberMember 1260015012-Oct-20 22:37 
AnswerRe: Should I store files in a database? Pin
Richard Deeming12-Oct-20 22:54
mveRichard Deeming12-Oct-20 22:54 
QuestionMYSQL Pin
Member 147129666-Oct-20 10:21
MemberMember 147129666-Oct-20 10:21 
AnswerRe: MYSQL Pin
ZurdoDev6-Oct-20 10:34
professionalZurdoDev6-Oct-20 10:34 
QuestionDatabase scripts version control process/strategy? Pin
Member 1363071429-Sep-20 6:06
MemberMember 1363071429-Sep-20 6:06 
AnswerRe: Database scripts version control process/strategy? Pin
David Mujica29-Sep-20 7:48
MemberDavid Mujica29-Sep-20 7:48 
AnswerRe: Database scripts version control process/strategy? Pin
ZurdoDev29-Sep-20 9:05
professionalZurdoDev29-Sep-20 9:05 
QuestionSimple Database design Pin
fdanos23-Sep-20 20:23
professionalfdanos23-Sep-20 20:23 
AnswerRe: Simple Database design Pin
Victor Nijegorodov23-Sep-20 20:54
MemberVictor Nijegorodov23-Sep-20 20:54 
AnswerRe: Simple Database design Pin
Mycroft Holmes24-Sep-20 12:18
professionalMycroft Holmes24-Sep-20 12:18 
QuestionWhy does MySQL not convert dates before 2010-01-01? Pin
fd97507-Sep-20 2:35
professionalfd97507-Sep-20 2:35 
AnswerRe: Why does MySQL not convert dates before 2010-01-01? Pin
Jörgen Andersson7-Sep-20 4:18
professionalJörgen Andersson7-Sep-20 4:18 

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.