Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

Server configuration details – PB Docs 90 – PowerBuilder Library

Server configuration details – PB Docs 90

Server configuration details

The servers and clients used by the Web DataWindow can run
on the same or different machines. The following diagram shows typical configurations
with the Web server and page server on the same machine and the
component server and database on separate machines, but any or all
of the servers can run on the same computer. In your development environment,
the client browser could be on the same computer too.

Figure 7-1: Typical Web target configurations

htmldw02.gif

Using the Web DataWindow
with PowerDynamo

If you install EAServer and PowerDynamo on the same computer,
most of the configuration is done for you. You can use PowerBuilder
Web Target wizards to perform any additional setup tasks.

However, if you design your own custom class user objects,
you must generate and compile the stubs, making sure that the compiled
stubs are included in the PowerDynamo class path.

note.gif CLASSPATH environment variable If you are not running your Web server as a service and you
have a user CLASSPATH environment variable, make sure that this
variable includes the paths to all classes needed for communication
between the Web server and the component server. This includes the
SybaseEAServerhtmlclasses directory and
the path to any component stubs that you generate for use with your
Web pages (if these are in a different directory). When you install EAServer,
the path information for the server is placed only in the system
CLASSPATH variable, not the user variable.

Using the Web DataWindow with Tomcat

To use Web DataWindows
and access EAServer components in JSP pages that you deploy to a
Tomcat server, you must add the following JAR files and classes
to the class path used by Tomcat at startup:

  • pbjdbc1290.jar
  • jconn2.jar
  • easclient.jar
  • easj2ee.jar
  • EAServer_homehtmlclasses
  • EAServer_homejavaclasses

where EAServer_home is the full
path to the EAServer where the Web DataWindow component is installed.
To add the required files to the Tomcat class path, you need to
edit the catalina.bat file in the Tomcat bin directory.

Using the Web DataWindow with a COM component

You can also use the Web
DataWindow with Microsoft servers, but more configuration tasks
are required. On MTS or IIS,
you access the COM version of the generic server component (PowerBuilder.HTMLDataWindow)
using automation methods called from any page server, such as PowerDynamo
or ASP. For example, to instantiate the generic COM component from
ASP:

The COM server component is provided in PBDWR90.DLL.
You can also write your own custom class user object based on the
sample source code in PBDWRMT.PBL.

For more information about building Web pages that use the
Web DataWindow server component, see “Instantiating and configuring
the server component”
.

You need to register the COM server component and install
PowerBuilder runtime files and the PBL or PBD containing your DataWindow
objects on the MTS or IIS server
computer.

Transaction server configuration
tasks

The following table summarizes the configuration tasks you
need to perform on the transaction server:

Table 7-1: Configuration tasks for transaction server
Server Tasks
EAServer, IIS,
or MTS
Copy the PBLs,
PBDs, SRDs, or PSRs containing the definitions of your DataWindow
objects to a directory on the EAServer server’s path
or the system path if the server component is running as a service
(always true for MTS or IIS).
EAServer Set up a DSN and a connection cache for
your data source.
IIS or
MTS
  • Copy the following
    PowerBuilder runtime files to the system path: PBVM90.DLL, LIBJCC.DLL, PBDWE90.DLL, PBODB90.DLL, PBODB90.INI
  • Copy the file containing the generic COM server
    component to the system path and register it:

  • If you designed your own custom class user object
    and built a COM server component, you need to copy your component DLL
    to the server and register it
  • If necessary, install the ODBC driver for your DBMS
    and use the ODBC Administrator to define an ODBC data source for your
    DataWindow objects as a system DSN
MTS If MTS is hosting the server component
and running on a different computer from IIS,
create a client install package using MTS Explorer and install it
on the IIS machine. For more information,
see the MTS documentation.

Page server configuration tasks

The following table summarizes the configuration tasks you
need to perform on the page server:

Table 7-2: Configuration tasks for page server
Server Tasks
PowerDynamo or ASP Copy the HTML pages, scripts, images,
and other application files to the page server. You can use the
Web target deployment controller for PowerDynamo or ASP to copy them
to the server.
JSP Copy the JSPs, custom tag libraries,
scripts, images, and other files to the page server. You can use
the Web target deployment controller for JSP to copy them to the
server.

Although a custom tag library you add to a page is placed
in the Web-Inf ld directory and deployed with the target,
you must manually copy any classes or archives required by the tag library.
Tag library class files should be copied to the Web-Infclasses
directory, and tag library archive files should be copied to the
Web-Inflib directory.

For information about the Web DataWindow custom tag library, see
the “Custom Tag Reference” chapter in the Web and JSP Target
Reference

.

PowerDynamo (with any component server) Create a Web site and define a mapping
in Sybase Central that associates the connection profile for your
database with the Web site pathname you will use in the URL. (The
PowerDynamo Web Site target wizard can do this for you.)
PowerDynamo (with EAServer as the component server) If PowerDynamo and EAServer are not
installed on the same computer:

  • Copy JAGCLIENT.EXE from
    the EAServer client subdirectory to the PowerDynamo server, run
    it, and select Java Runtime.
  • Add SybaseSharedSunjdknnnin
    to the system PATH environment variable.
  • Add SybaseSharedSunjdknnnlibclasses.zip
    to the CLASSPATH environment variable.

In Sybase Central, open the General Settings folder in the PowerDynamo Configuration
utility and check that the Sun Java VM is selected (the default).

ASP (with EAServer as the component server) If ASP and EAServer are not installed
on the same computer:

  • Copy JAGCLIENT.EXE from
    the EAServer client subdirectory to the ASP server, run it, and
    select ActiveX Runtime.
  • Copy PBDWR100.TLB and PBDWR100.REG to
    the ASP server from the SybaseSharedPowerBuilder
    directory on the computer where PowerBuilder is installed.
  • Edit the HKEY_CLASSES_ROOTTypeLib
    lines in PBDWR100.REG that show the
    location of the PBDWR100.TLB file to
    show the correct location on the ASP server.
  • Double-click PBDWR100.REG to
    install its information into the Windows registry.

If you designed your own custom class user object, generate TLB
and REG files for the component in Jaguar Manager and register them
on the ASP server. For more information, see the chapter on creating
ActiveX clients in the EAServer Programmer’s
Guide

.


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x