Solved

VB/ADO - Oracle - run time install files

Posted on 1998-11-20
5
282 Views
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.

Thankyou.

0
Comment
Question by:insearch
  • 3
  • 2
5 Comments
 
LVL 1

Expert Comment

by:stevesm
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
0
 

Author Comment

by:insearch
ID: 1497755
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
 
LVL 1

Expert Comment

by:stevesm
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
0
 

Author Comment

by:insearch
ID: 1497757
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
 
LVL 1

Accepted Solution

by:
stevesm earned 100 total points
ID: 1497758
Thanks insearch,
If you need more help, send me an email.
Regards Stevesm
gosport52@hotmail.com
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
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…
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…

705 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now