[Last Call] Learn how to a build a cloud-first strategyRegister Now


PowerBuilder, InstallShield and Personal Oracle 8i

Posted on 2001-08-25
Medium Priority
Last Modified: 2013-12-26

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?
Question by:jnowlin
  • 5
  • 5

Expert Comment

ID: 6425345
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.

Author Comment

ID: 6426423
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.


Expert Comment

ID: 6426952
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.

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.


Author Comment

ID: 6428557
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?


Expert Comment

ID: 6428669
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.

Accepted Solution

Bhatti earned 400 total points
ID: 6429978
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.


Author Comment

ID: 6449002
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.


Author Comment

ID: 6602127
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!


Author Comment

ID: 6602136
Thanks Bhatti for your time as well as your patience.


Expert Comment

ID: 6603718
Thanks for your friendly comments.


Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project (http://www.eclipse.org/sequoyah/) automates most of the tasks discussed in this article. You can even fin…
How to install Selenium IDE and loops for quick automated testing. Get Selenium IDE from http://seleniumhq.org Go to that link and select download selenium in the right hand column That will then direct you to their download page. From that p…
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.

826 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