• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 342
  • Last Modified:

VB/ADO - Oracle - run time install files

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.

Thankyou.

0
insearch
Asked:
insearch
  • 3
  • 2
1 Solution
 
stevesmCommented:
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
0
 
insearchAuthor Commented:
Stevesm,

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.
0
 
stevesmCommented:
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
0
 
insearchAuthor Commented:
Stevesm,

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.

Thx


0
 
stevesmCommented:
Thanks insearch,
If you need more help, send me an email.
Regards Stevesm
gosport52@hotmail.com
0
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

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now