Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Calling PowerBuilder object in ASP.NET

2 posts in Objects Last posting was on 2003-11-10 21:40:06.0Z
PA Posted on 2003-11-10 20:27:07.0Z
Sender: 7474.3faff462.1804289383@sybase.com
From: pa
Newsgroups: sybase.public.powerbuilder.objects
Subject: Calling PowerBuilder object in ASP.NET
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3faff49b.7475.846930886@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 10 Nov 2003 12:27:07 -0800
X-Trace: forums-1-dub 1068496027 10.22.241.41 (10 Nov 2003 12:27:07 -0800)
X-Original-Trace: 10 Nov 2003 12:27:07 -0800, 10.22.241.41
Lines: 33
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:7662
Article PK: 734941

I'm calling a PowerBuilder 6.5 object in an asp.net page
and am having some perfomance issues.
Here's the code:

dim pb as object
dim g_objPB as object

pb = CreateObject("Powerbuilder.Application")
pb.LibraryList = "c:\web\power.dll"
pb.MachineCode = False
g_objPB = pb.createobject("m_class")

The code executes appropriately, however the line:

pb.LibraryList = "c:\web\power.dll"

takes at least 15 seconds to process.
when i make these calls from a windows project they are
almost instantaneous.
my thinking is it's a security issue but am not exactly
sure what that issue is. I've tried anonymous access and
windows integration with no change in performance.

my workaround is to call a separate thread that executes
the above code and puts the object into a global variable,
although that's not my desired solution.

The operating system is windows 2000 server.

any help would be greatly appreciated.

thanks
pa


Paul Horan[TeamSybase] Posted on 2003-11-10 21:40:06.0Z
From: "Paul Horan[TeamSybase]" <paulhATvcisolutionsDOTcom>
Newsgroups: sybase.public.powerbuilder.objects
References: <3faff49b.7475.846930886@sybase.com>
Subject: Re: Calling PowerBuilder object in ASP.NET
Lines: 41
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 67-23-180-28.bflony.adelphia.net
X-Original-NNTP-Posting-Host: 67-23-180-28.bflony.adelphia.net
Message-ID: <3fb005b6$1@forums-1-dub>
Date: 10 Nov 2003 13:40:06 -0800
X-Trace: forums-1-dub 1068500406 67.23.180.28 (10 Nov 2003 13:40:06 -0800)
X-Original-Trace: 10 Nov 2003 13:40:06 -0800, 67-23-180-28.bflony.adelphia.net
X-Authenticated-User: TeamPS
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:7663
Article PK: 734939

I would get a copy of FileMon (www.sysinternals.com) and see what that shows. It lists all files being accessed by the
machine in chronological order. That may help solve the problem...

Paul Horan[TeamSybase]

<pa> wrote in message news:3faff49b.7475.846930886@sybase.com...
> I'm calling a PowerBuilder 6.5 object in an asp.net page
> and am having some perfomance issues.
> Here's the code:
>
> dim pb as object
> dim g_objPB as object
>
> pb = CreateObject("Powerbuilder.Application")
> pb.LibraryList = "c:\web\power.dll"
> pb.MachineCode = False
> g_objPB = pb.createobject("m_class")
>
> The code executes appropriately, however the line:
>
> pb.LibraryList = "c:\web\power.dll"
>
> takes at least 15 seconds to process.
> when i make these calls from a windows project they are
> almost instantaneous.
> my thinking is it's a security issue but am not exactly
> sure what that issue is. I've tried anonymous access and
> windows integration with no change in performance.
>
> my workaround is to call a separate thread that executes
> the above code and puts the object into a global variable,
> although that's not my desired solution.
>
> The operating system is windows 2000 server.
>
> any help would be greatly appreciated.
>
> thanks
> pa