Solved

Installation guidance

Posted on 2002-07-08
14
256 Views
Last Modified: 2013-11-13
Hi,

I've prepared an application in vb 6 using access 2002(office xp)database. My package and deployment wizard gave me all sorts of errors so i used a third party setup creater. I created a setup using "wise installer" which worked fine for the Windows XP platform. However, the application does not work on windows 98. I've tried quite a few thing to fix this like converting to access 97 (oledb 3.51) so on and so forth.  The setup i have installs ok but gives errors at times of unable to connect to db and lately i'm getting the error "error 7. out of memory". i have tried installing mdac 2.5 on one win98 machine (with no msoffice or vb) and it worked. However on another machine it didnt !

In a nutshell how can i create single setup which can be installed on any windows platform.
0
Comment
Question by:khurshid
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
  • 2
  • +3
14 Comments
 
LVL 22

Expert Comment

by:rspahitz
ID: 7138235
Normally, the VB package and Deployment wizard is very good at identifying all necessary pieces...other than special add-ins like databases and auxiliary files.

If it's giving you problems, you might want to start by examining your project references.  Maybe some of them are incompatible with XP.  Can you list some of the errors?
0
 

Author Comment

by:khurshid
ID: 7138343
I created the project in XP environment and it works fine there. My P&D wizard just closes when i click the final "finish" button without an error message. However, i mentioned that i installed on XP (different machine than the one i developed on) using Wise Installer and its working.
I am open to any suggestions . I just have to make sure the setup installs on all windows (ie 9x,2000 & xp)
0
 

Author Comment

by:khurshid
ID: 7138471
I created the project in XP environment and it works fine there. My P&D wizard just closes when i click the final "finish" button without an error message. However, i mentioned that i installed on XP (different machine than the one i developed on) using Wise Installer and its working.
I am open to any suggestions . I just have to make sure the setup installs on all windows (ie 9x,2000 & xp)
0
Is Your DevOps Pipeline Leaking?

Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations

 
LVL 44

Expert Comment

by:Arthur_Wood
ID: 7138564
"I created the project in XP environment " is the ENTIRE source of your problem.  An application created under XP WILL NOT (almost 100% certain) be compatible with earlier Windows versions.  

It is almost always a VERY VERY bad idea to try to make an application that is BACKWARDS compatible.  The biggest problem will be that DLLs that are internal to the Newer operating system WILL ALMOST ALWAYS not be loadable under the older version of the operating system.  It is ALMOST always advisable to create the application with the LOWEST (earliest) version of the operating system that you intend to support.  It is again, ALMOST ALWAYS the case that the Newer version of the operating system WILL support applications created with an earlier version, but not the other way around.

Arthur Wood
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 7138858
Agree with Arthur Wood.  We have a mix of 95, 98, 2000, and NT.  We are doing the development on Win 95 machines and have installed to all other platforms with minimal problems.

good luck
mlmcc
0
 
LVL 22

Expert Comment

by:rspahitz
ID: 7138864
Although I agree in concept, Microsoft has done a very good job with making all upgraded components backward-compatible.  However, since XP uses a lot of new components and they all have NT security in mind, there certainly could be some issues with that.

Can you take the source code and bring it to another non-XP machine to see if it will run?  If not, you'll know what pieces are missing.  Is so, try running the deployment wizard from that machine.
0
 
LVL 4

Accepted Solution

by:
AlonHirsch earned 50 total points
ID: 7145352
I agree with Arthur Wood too - a lot of the VB Runtimes and OS files (Kernel, User etc.) are updated with each version of the OS.
In fact - XP has a newer MSVBVM60 than shipped in SP5!

One of the other problems could be the JET stack.
As of ADO 2.5 - The JET (Access) components are no longer included in the MDAC install.

Try installing these on the PC where the app does not work and see if that solves the problem.

I agree with the sentiments above - always compile and deploy from the LOWEST common OS - in this case '95.
We do and have had no problems, but when we deployed from NT - some '95 and '98 installations failed due to incorrect DLL versions.

HTH,
Alon
0
 

Author Comment

by:khurshid
ID: 7145671
hmmm..
I shifted the project to win98 and had the same P & D problem. The project DID run on the development  machine but i had the same problems running on other 98 machines. However XP did run the project. From your discussions i can safely assume why.

I do agree development should take place on the lowest common OS but my development team was probably too naive in that approach.

As for the problem at hand.. we finally found that it due to a faulty VB dll (windows common controls 6.0) FM20.dll. We downloaded the patch for it from microsoft and the project has started to install.

I would like to focus the question back to where i started it and need ur guidance in the installation process for future. I need minimum required drivers so that my access db (at the backend of the application) could run on any win9x and win2k/nt machines.Which version of access should i use to develop the db. Should i install mdac2.5 along with the application? should i use any other version? What if there was a newer version of mdac already installed. Besides ocx controls and vb references, what else needs to be installed to make sure the application runs on a machine.

thanx.
0
 
LVL 4

Expert Comment

by:AlonHirsch
ID: 7145723
Hi,

We have found that in order get applications to install and function correctly, we need to ensure that IE is installed (we install IE 5.5 SP2), MDAC (we install all versions - 2.12, 2.5, 2.6 and 2.7) and JET 4.0 SP3 to ensure that Access compatibility is maintained.

Once these have been installed - we install our software which then seems to run without any glitches.
Our software is developed in VB6, and uses RDO and ADO (the RDO is left over from VB5 and we have not had the time to conver the app completely to ADO).

I know you are looking for the simplest solution, but we have found that simple isn't always sufficient,and have opted for a complete / thorough installation instead.

The only other problems we've encountered are with COMCAT.DLL. Apparently, the versions of OLEAUT32 and COMCAT are tightly integrated. On some NT machines, we've had problems where a newer version of COMCAT.DLL is installed by our APP and then certain things fail to register or run.

There is an MSDN article on this, but I do not have the reference handy.

HTH,
Alon
0
 
LVL 22

Expert Comment

by:rspahitz
ID: 7146779
We recently resolved a problem with installing on 98 from a 2000 package.  It turned out to be that SHLWAPI.dll was being upgraded and caused Windows to fail, presumably because this has a hidden dependency on something else.

With InstallShield, we told it to simply ignore installing this if it already exists.  Now the install works.

Normally, you tell the installation app to only *upgrade* components (i.e. replace if there is a newer version or, if no version stamp, a newer timestamp.)

We've also had to tell it to install MDAC (we just use 2.5 for our ADO) ... IF MDAC is not already installed.
0
 

Author Comment

by:khurshid
ID: 7152226
hi again,
Thank you for your help.
I need to split the points. how do i do that ?

0
 
LVL 22

Expert Comment

by:rspahitz
ID: 7154869
Add a zero-point question in the Customer Support topic area with this question's URL and how you'd like the points split.  They'll then give you further instructions.
0
 
LVL 6

Expert Comment

by:Mindphaser
ID: 7159871
khurshid

I reduced the points to 50 and refunded the rest. Please accept AlonHirsch's comment as an answer and post questions for Arthur Wood (30p) and rspahitz(20p) with a title like : "Points for xxx" and a body "For your help in <URL>."

** Mindphaser - Community Support Moderator **
0
 
LVL 6

Expert Comment

by:Mindphaser
ID: 7177901
Force accepted

** Mindphaser - Community Support Moderator **

Arthur Wood and rspahitz, there will be a separate question with points for your help.
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
If you don't know how to downgrade, my instructions below should be helpful.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question