VB/ADO - Oracle - run time install files

Posted on 1998-11-20
Medium Priority
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
  • 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 http://www.ghost.com 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 200 total points
ID: 1497758
Thanks insearch,
If you need more help, send me an email.
Regards Stevesm

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
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…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

569 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