PowerBuilder, InstallShield and Personal Oracle 8i


I am working on a project in PowerBuilder 7.0. I have an evaluation copy of InstallShield and I'm working in Oracle using Personal Oracle 8i.

Since the academic version didn't come with the PowerBuilder the PowerBuilder Deployment Kit, I choose to use InstallShield. It is a very complex program.

Is there any documentation out there on using InstallShield? What files must I include from PowerBuilder, Personal Oracle, etc.?

Any suggestions?
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

BhattiConnect With a Mentor Commented:
Hello Jim,

InstallShield 5.0

I don't think a ig difference among the other versions of the InstallShield.

1)    When you start your InstallShield click there on Project Wizzard.

2)    This leeds you to select and the information for your setup file(s). You can choose the components         which you want to add with you setup file and others informations.

3)    After completing the wizzard, InstallShield will open you a window with some tabpages.
                          Hier you  should code the name of you executeable(EXE)  file.
                          function SetupFolders()
                          STRING szProgramFolder, szItemName, szCommandLine, szWorkingDir, szIconPath;
                          STRING szShortCutKey, szProgram, szParam;
                          NUMBER nIcon, nFlag;
                                    szProgramFolder = "abcdef"; //for start menu folder name
                                    szItemName    = svDefGroup;
                                    //your exe file name with extension .exe and first two backslashes must be written
                                    szProgram = svDir + "\\your.EXE";
                                    szParam   = "";
                                    szCommandLine = szProgram + " " + szParam;
                                    szWorkingDir  = "";
                                    szIconPath    = "";
                                    nIcon         = 0;
                                    szShortCutKey = "";
                                    nFlag         = REPLACE;
                                    if (AddFolderIcon(szProgramFolder, szItemName, szCommandLine, szWorkingDir,
                                        szIconPath, nIcon, szShortCutKey, nFlag) < 0) then
                                         MessageBox("Cannot add Folder.", SEVERE);

                                   return 0;
                        Look this (above) function  care fully in InstallShield tabpage script. and some other function if                         you need.
                        Hier are components as Help files , Program DLLs, Program Example Files, Shared Dlls
                        Hier you need to add the File groups. When you click on the Program files you see the small
                        information on your right side. read all rows carefully and add the information.Among them the                         most important is "include file groups" . Hier double clicked will open you to select the file                         groups. File groups are Help Files , Program DLLs, ProgramExecuteableFiles,
                        Example Files, Shared DLLs and so on.
                        In component folder in Program Files you add the program dlls or(PBDs) and executeable
          FILE GROUPS:
                        Hier you must add the language and Systems (window 95 or 98 Windows NT etc)
                        you will see when doubledclicked on the row.

Same with tabpages and in Media tabpage is also wizzard will leeds you to make a setup files.

Best regards and please let me know if you have any question.

I worked with installshield and know some commands how to work with InstallShield except "how to put program in Start Menu". I have this question also.

So you need .PBD ( or dll ) files which you have built from PB project. You need all files related to your program as PRD files example files and exe file of your program.

You can select the directories in InstallShield where which file you should place, e.g in executeable directory you place the exe file and in program files you place the files which you have build during your project. These are dll files from your PBLs or PBD files from your PBLs.

then you should place the PB deploy Kit (dlls) these are different. If you are using Oracle then you need also the PB run tile Libraries (dll) for Oracle my be PBO70.dll or like this but you need not to place the dlls for other databases. these should place in the directory in InstallShield Shared DLLs some of them writing here:

Directories in InstalShield:      

Help Files        // all your Help files
Prgram DLLs  // your dlls from PB or PBD files from PB during making Proj.
Program Executeable files // you exe files
Shared Dlls //PB deployment Kit my you find in C:\Program\powersoft\DDDK7\deployment Dlls
Example files //if you have some example files.

So you need

You dlls or pbd files created by project
you need PB deloyment kit dlls I wrote the directory where you can find PB dlls and for Oracle also
you need you exe files you need example files and all ther a prb and other neccessary for your Project

If you have further question write me If I can will write you further.
jnowlinAuthor Commented:
Hi Bhatti,

I don't believe I have the PB Deployment Kit for, as you suggest:

"then you should place the PB deploy Kit (dlls) these are different"

Shared Dlls //PB deployment Kit my you find in C:\Program\powersoft\DDDK7\deployment Dlls

I'm using PB version 7.0 by Sybase. It's an academic version which did not include the PB Deployment Kit. Hence, the choice to use another packaging kit, an evaluation version of InstallShield.

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Hallo Jim,

You must have somewhere in your harddisk the deployment kit. Must not be in the Path I wrote may somewhre else.  Deployment kit doesn't mean the programm dlls that you can build a setup program.
With InstallShield you can build a professional SetUp program. In InstallShield you need to add these files (copying).

These Shared dlls are (some examples). Find them in your harddisk with search.


and etc.

Try to find as pb*.dll files with search program.

You need add these dlls in your InstallShield program in Shared DLLs directory.

Jim if InstallShield is complex I shall write you what to do in script create the setup file, and in other Directories creating in InstallShield Program.

With InstallShield you create a setup program for your project and add the files as dlls or pbd files of your program,  help files, example files, related files to your program and shared dlls of PB. (such dlls I wrote above).

Please let me know first what is real question. You want to create a setup program that others can install it automatically from disk? Is is so or me is FALSE?

Waiting for your repley.

jnowlinAuthor Commented:
Yes Bhatti, hello -

I would like to create a 'Setup.EXE' program which can be run to install the PB program on a PC running Windows98, 2000, Me, etc.

Meanwhile, I will look for those pb*.dll files. I am not currently at the PC which has PowerBuilder and the project installed on it. Will one (or more) of these Dynamic Link Library files take care of the Oracle part of the project?

PB runtime libraries (dlls) you can find only in PC where you installed your PB7.0.
These dlls you need to add in InstallShield.
There is a dll like PBOR80.dll (this is not an exact name but like), this or such dlls related to Oracle 8 you should add in InstallShield. This(these) dlls will care for Oracle. I don't know you have a direct access to Database or with ODBC.

With Powerbuilder kit Sybase attached a book "connecting to your database" please refer it and you can find the name (names) of the dlls special for ORACLE.

Other dlls you need also as PBMV70.dll and such as PBTRA70.dll. All such DLLs you need also to add in InstallShield.

Later I shall write you a small description of the InstallShield How and whrer what to write the others you can follow.

Install your InstallShield program in the PC where you installed PB7.0, because you need the dlls to add in InstallShield.
jnowlinAuthor Commented:
It's going to take longer than expected to work with you on this question, also.

This past Thursday, I was told I must vacate my appartment by no later than October 1, 2001.
I will need to use more time to look for a place to live.
Please bear with me.

jnowlinAuthor Commented:
Hi Bhatti,

I'm going to accept your answer, even though I have been away from this project for nearly two months. It's not fair to you to leave this question up in the air.

I'm going to get back up to speed soon. I found a nice new place to live. So, I will return to this. I will probably post another question regarding this once I get back into the 'swing of things'. I don't know which is worse moving or unpacking all of one's stuff!

jnowlinAuthor Commented:
Thanks Bhatti for your time as well as your patience.

Thanks for your friendly comments.

All Courses

From novice to tech pro — start learning today.