VB/ADO - Oracle - run time install files

Posted on 1998-11-20
Last Modified: 2013-12-25
my prgrammers are developing a VB5.0 app and using ADO to access oracle 7.3.3 database on the unix server. To create a run time install disk containing all relevant files on the client for VB5,ADO and oracle they need some help.

The VB files required are documented in VB docs. what files are required for ADO and Oracle is a mystry. presently they  follow the brute force approach and manually install all oracle files.

i would like to know the list of files and can we care one install program for the complete system.. if it is too much of a hassle to list files,, any pointers where i can get those documenattion would be helpful.


Question by:insearch
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
  • 3
  • 2

Expert Comment

ID: 1497754
Hi insearch,
We have had simlilar experience installing mulitple applications using Oracle as the back end and VB as the front end on many workstations. When installing Oracle you need the run time files that Oracle uses and the registry entries that it provides. With the appropriate licenses we use Oracle on the server and make all pointers in the registry point to that server after installing Oracle on the client machine. There is too much detail to go into here but I don't think your programmers are doing anything too labour intesive. The method we used was to use an image once one workstation is created and use a program to duplicate the image on the workstation. Upload it to the server and then download the image to the other workstations. With some minor adjustments for IP and/or DHCP. Everything is great, of course your workstations need a lot of similarity in hardware configurations.
If you need more help or have any questions let me know and I can try and help.

Regards Stevesm

Author Comment

ID: 1497755

Thx for the reply! little bit clear but i need some clarificatioin.. when u say "run time files that oracle uses and the registry entries that it provides" .. my question is what are those run time files? do we use the oracle install disk
that comes with the product.. how do we know what files are in the image..

i was hoping that say by using setup program on VB, we can create one installation program that

1. install VB components
2. install oracle components
3. update registry..

does it make sense or maybe i am talking gibberish.. pls bear with me.

Thx once again.

Expert Comment

ID: 1497756
I realize what your trying to do, but I guess in short I was saying it can be done with perhaps less work than if you copy the image of a standard workstation setup, it saves vast amounts of time when installing multiple workstations of similar configuration. In our case windowsNT, office '97, Service Pack 3 for NT and Service Pack1 for office '97 along with the configuration of the workstation and various other programs like Sequel Net (Oracle) and ODBC configurations. We only do it once and then download the image onto the PC's. If any standards within our Company changes we just recreate the image and download it onto the PC's again.

The program we use for disk imaging is called Ghost, it is a disk copying program made  by Symantec. I think the web page is for more info.

 If you really want to track the changes that are being made with the install files for Oracle and registry changes. We use a program called InCtl3 its  good for tracking changes to the computers registry, files, etc. and will give you a report for changes that have been made by the install program such as Oracle. You need to start Inctl3 and then install the Oracle files using the interface provided with InCtl. Then you could add the files and registry changes that the report issues in the setup file of the VB install. One word of advise, the files installed with Oracle and the registry changes it makes are huge, the last time I looked at the Inctl report for installing Oracle there were over 800 changes to the registry!

Although this isn't necessary for imaging used by Ghost. If you intend to "Ghost" the client workstation and then download the image to another machine then tracking the changes are unecessary. Ghosting will erase the contents of the hard drive when you download the image onto another computer. The problem with this method is that the users dont want their hard drives erased. Its easier when you are planning to roll out a bunch of new workstations.

Perhaps I've only made things worse by making these comments......... but I hope I answered most of your questions, please feel free to ask more info or clarification.

Regards Stevesm

Author Comment

ID: 1497757

thx a lot for that. i appreciate u giving u'r time.

in fact, for other piece of software (office 97 etc etc) we are using the image approach as all the workstations have identical configuration. that makes sense if the configuration of workstations is in your control

the way i was looking at was .. what if decide to sell the product, then in that case we will have to provide all the relevant files for it to run. for eg. the way we buy quicken. the install program installs all the relevant files and sets up the registry.

i guess in this  case , we may have to provide instructions  to install oracle on the client
in a certain way and then install the VB/ADO part of the product. ideally it would have been nice
to know what specific oracle files my product uses, what registry entries are important (run time only) and provide those files..

but, in short term i think i will follow u'r advise and follow the image approach for the app. since the taking the product to outside the controlled environment is some way ahead.



Accepted Solution

stevesm earned 100 total points
ID: 1497758
Thanks insearch,
If you need more help, send me an email.
Regards Stevesm

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
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…

733 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