Connect database when start with window

[capint]

I mean that I connected successfully & I used it properly when I directly click on the application file. It just doesn't do well when start with window. Here is a part of my code. Plz help me :confused:

iSize = 0;
DateTimeNote Temp;
bool bFlag = true;
Open("Provider=Microsoft.Jet.OLEDB.4.0; \
Data Source=DateNote.mdb");
CString sql;
variant_t vNull;
variant_t TheValue;

vNull.vt = VT\_ERROR;
vNull.scode = DISP\_E\_PARAMNOTFOUND;

CString StrResult;
CString StrSql;
CString StrDateTime;
CString StrDateTimeTemp;

StrDateTime.Format(_T("%i/%i/%i"),DateTime.GetMonth(),DateTime.GetDay(),DateTime.GetYear());
StrSql.Format(_T("SELECT * FROM DATETIMENOTE WHERE NGAY = '%s'"), StrDateTime);

m_pRecordset.CreateInstance(__uuidof(Recordset));
m_pRecordset->PutRefActiveConnection(m_pConnection);
m_pRecordset->Open(_variant_t(StrSql), vNull, adOpenForwardOnly, adLockOptimistic, adCmdText);

while (!m_pRecordset->GetEndOfFile())
{
TheValue = m_pRecordset->GetCollect("GIO");
if(TheValue.vt != VT_NULL)
{
StrResult = (char *)_bstr_t(TheValue);
StrDateTimeTemp = StrDateTime + _T(" ") + StrResult;
Temp.DateTime.ParseDateTime(StrDateTimeTemp, LOCALE_NOUSEROVERRIDE, LANG_USER_DEFAULT);
}
TheValue = m_pRecordset->GetCollect("NOTE");
if(TheValue.vt != VT_NULL)
{
StrResult = (char *)_bstr_t(TheValue);
Temp.Note = StrResult;
}
pTemp[iSize] = Temp;
iSize ++;
m_pRecordset->MoveNext();
}

[Rajesh R Subramanian]

Did you try debugging the application? Where is the crash happening?

Nobody can give you wiser advice than yourself. - Cicero .·´¯`·->Rajesh<-·´¯`·. Codeproject.com: Visual C++ MVP

[capint]

How can I debug the application ? It worked properly when I debug in VC. When window starts, it just announces a message

[Rajesh R Subramanian]

capint wrote:

How can I debug the application ?

By setting a breakpoint and starting the debugger.

Nobody can give you wiser advice than yourself. - Cicero .·´¯`·->Rajesh<-·´¯`·. Codeproject.com: Visual C++ MVP

[capint]

Can you explain more ? Where to put the breakpoint & how to start the debugger ? I mean with the application (file with the extension .exe)

[Cedric Moonen]

I think his application is started as a service when windows starts, so it's a bit too late to open VC and attach the debugger ;)

Cédric Moonen Software developer
Charting control [v1.4]

[Rajesh R Subramanian]

May be. But I couldn't make out anything from what he said. :)

Nobody can give you wiser advice than yourself. - Cicero .·´¯`·->Rajesh<-·´¯`·. Codeproject.com: Visual C++ MVP

[Cedric Moonen]

The hint is in the title and in his previous message ;)

Cédric Moonen Software developer
Charting control [v1.4]

[Rajesh R Subramanian]

You can also print status messages using OutputDebugString[^] and use an external debugger like DebugView[^]to view those messages. Find out where exactly your application is crashing and start investigating that portion of code.

Nobody can give you wiser advice than yourself. - Cicero .·´¯`·->Rajesh<-·´¯`·. Codeproject.com: Visual C++ MVP

[capint]

So have you ever tried to connect to database through ADO and make it run with window ? Plz give me some code examples :sigh:

[Rajesh R Subramanian]

window != Windows for me. I actually thought he is talking about some window. Or may be that I'm not smart enough. :)

Nobody can give you wiser advice than yourself. - Cicero .·´¯`·->Rajesh<-·´¯`·. Codeproject.com: Visual C++ MVP

[Cedric Moonen]

Naaah, it's just that you didn't use your CPMRU properly :)

Cédric Moonen Software developer
Charting control [v1.4]

[Rajesh R Subramanian]

:laugh:

Nobody can give you wiser advice than yourself. - Cicero .·´¯`·->Rajesh<-·´¯`·. Codeproject.com: Visual C++ MVP

[capint]

I'm sorry if my question is so vague. I meant Windows :sigh: I put my application path in registry (create a value in ...\Run) and I repeat my application works well when I debug in VC. It just doesn't work when Windows starts :(

[David Crow]

Have you seen this?

"Love people and use things, not love things and use people." - Unknown

"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne

[capint]

:(( I've searched for many hours but I found no result ... Some one has mentioned that problem but they didn't solve it ...

[David Crow]

Have you tried the hotfix from Microsoft?

"Love people and use things, not love things and use people." - Unknown

"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne

[capint]

I don't know :-O I will wander some IT forum to ask if anyone has the same problem. Thanks for all of your answers :)

[David Crow]

capint wrote:

I don't know

How can you not know if you've installed a hotfix or not? :rolleyes:

"Love people and use things, not love things and use people." - Unknown

"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne

[Rajesh R Subramanian]

Don't get me started. He may not know. But, you should know it. Just get your CPMRU started. :laugh:

Nobody can give you wiser advice than yourself. - Cicero .·´¯`·->Rajesh<-·´¯`·. Codeproject.com: Visual C++ MVP