Visual Basic 6.0 generated program executable failing on a 3.6 GigaHertz machine

To all,

I have 14 programs developed in Visual Basic 6.0 and have been compiled to EXEs

We recently wanted to upgrade the computer these programs run on to decrease (hopefully) the run times as they are very very data and manipulation intensive.

Each program uses a Foxpro.dbf file to create and OLAP .cube file.  One File in, One File Out. The Contour Cube 3.0 component is used for the conversion and definition of the .cube files.

The programs compile OK on both computers BUT

Programs run normally on

Computer 1:   8 Gigabytes RAM, Windows Server 2008 R2 Standard, 2.6 GigaHertz (Xeon)
Maximum CPU usage 50%  maximum memory used 1,300,000K

8 of 14 Programs fail with an APPCRASH error on

Computer 2:  8 Gigabytes RAM, Windows Server 2008 R2 Standard, 3.6 GigaHertz (Xeon)
Maximum CPU usage 6% maximum memory at crashes is 600,000K

There does not seem to be any relation to the size of the input files or output files to the programs which crash.

Is there a possibility the programs are not playing well in the higher speed environment?

Any Ideas on how to fix?

Thanks
wheat01Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
I Googled APPCRASH and got a lot of hits including this one and this one which is a help line that you can call (most likely for a fee).
0
Éric MoreauSenior .Net ConsultantCommented:
are you able to isolate the statement that causes the error? I am pretty sure it isn't hardware related but a dependency not properly installed.
0
wheat01Author Commented:
the line of code is the last event called from the contour cube component.

with contourcubex7
   .property
   .property
   .property
   .rsdbf.open    ' causes the error only in 8 of 14 programs which have the same code
end with
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Éric MoreauSenior .Net ConsultantCommented:
and what is contourcuve? is it properly installed on the computers? can it be related to regional settings?
0
wheat01Author Commented:
it turns out it was the version of mdac installed on the non-performing machines. Something to do with how null values are handled.  We installed an eariler version of the mdac and all programs are working fine on all machines.

You all may want to log this as a possible approach if programs utilizing ODBC are showing erratic behavior on different machines.

Thanks for your consideration of this question, but I would say we are closed out at this point.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.