Problems with an application using ADO

[Enrico Maria Giordano]

Dear friends, have you ever had problem with ADO? My customer says that the application freezes at random point and loose the buttonbar icons. Other applications using DBFs works fine. It says that the problem started a couple of days ago. I can't reproduce it in my XP (he's using W7).

Any ideas?

EMG

[Armando]

Enrico:

A clue, some times when I forgot to close a table or when open and re open the same table
I receive that problem.

Regards

[Enrico Maria Giordano]

Armando,

Enrico:

A clue, some times when I forgot to close a table or when open and re open the same table
I receive that problem.

Regards

Thank you. My client said that he got the problem while the application was not being used at all (launched but not used).

EMG

[Armando]

Enrico:

Another clue, put several msginfo() in your main prg to see where it stops.

regards

[Rick Lipkin]

Enrico

Just a wild idea .. had a program that would always fail when a user did a screen shot capture .. and it turned out I had an ON PAINT clause on the window they were doing the screen captures on.

What I am getting at is ON PAINT captures Windows messages and sometimes just having the screen open ( inactive ) and your form has an ON PAINT .. will capture other programs messages and cause some un-intended failures of your program.

Also .. as far as ADO .. some will disagree with me, but I do not use an active connection to define my recordsets .. when I need data .. I just create the oRs with the sql statement and the connection string "on demand".

Rick Lipkin

[James Bott]

Enrico,

I have had images disappear from buttonbars due to memory leaks.

The memory leak could be in another program too.

James

[Antonio Linares]

Enrico,

I would suggest to keep a log file using FWH function LogFile() and save there the used memory, time, date, executed function, system memory...

http://wiki.fivetechsoft.com/doku.php?id=fivewin_function_logfile

just to have an idea what may be going on. Also Rick suggestion for not having opened connections seems very interesting.

Rick, would you mind to post a small example of how you do it ? thanks!

[Enrico Maria Giordano]

Armando,

Enrico:

Another clue, put several msginfo() in your main prg to see where it stops.

regards

Unfortunately, the problem is totally random. And as I already said, I was not able to reproduce it.

EMG

[Enrico Maria Giordano]

Rick,

Enrico

Just a wild idea .. had a program that would always fail when a user did a screen shot capture .. and it turned out I had an ON PAINT clause on the window they were doing the screen captures on.

I do have an ON PAINT clause on the main windows. It's for painting the main screen logo. I'll try to disable it, thank you.

Also .. as far as ADO .. some will disagree with me, but I do not use an active connection to define my recordsets .. when I need data .. I just create the oRs with the sql statement and the connection string "on demand".

Me too.

EMG

[elvira]

Enrico,

We are experimenting network problems with BCC 5.82, that disappear using latest BCC 6.6.

Hope it helps.

[Enrico Maria Giordano]

James,

Enrico,

I have had images disappear from buttonbars due to memory leaks.

The memory leak could be in another program too.

James

Thank you, I'll give it a look.

EMG

[Enrico Maria Giordano]

Antonio,

Enrico,

I would suggest to keep a log file using FWH function LogFile() and save there the used memory, time, date, executed function, system memory...

http://wiki.fivetechsoft.com/doku.php?id=fivewin_function_logfile

just to have an idea what may be going on.

I'll try it, thank you.

Also Rick suggestion for not having opened connections seems very interesting.

I already use that.

EMG

[Enrico Maria Giordano]

Elvira,

Enrico,

We are experimenting network problems with BCC 5.82, that disappear using latest BCC 6.6.

Hope it helps.

Thank you. I have no errors using DBF so I don't think it's a network problem. However, I'll try with BCC 6.6.

EMG

[elvira]

Enrico,

We do experiment data loses and sometimes hangs up the application.

That did not happen with XP.

BCC 6.60 seems to be working better with Windows 7 and 8.

[Enrico Maria Giordano]

Elvira,

Enrico,

We do experiment data loses and sometimes hangs up the application.

That did not happen with XP.

BCC 6.60 seems to be working better with Windows 7 and 8.

My client is using W7 and applications with DBF and with ADO and is only having problem with the one using ADO. But I'll try BCC 6.60, thank you.

EMG