FiveTech Software tech support forums

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

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

Armando,

Armando wrote: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

Enrico:

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

regards

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

Enrico,

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

The memory leak could be in another program too.

James

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!

Armando,

Armando wrote: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

Rick,

Rick Lipkin wrote: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.

Rick Lipkin wrote: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

Enrico,

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

Hope it helps.

James,

James Bott wrote: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

Antonio,

Antonio Linares wrote: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.

Antonio Linares wrote:Also Rick suggestion for not having opened connections seems very interesting.

I already use that.

EMG

Elvira,

elvira wrote: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

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.

Elvira,

elvira wrote: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