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.

HTML Datawindow Jaguar and IIS ASP. Help Please

3 posts in General Discussion (old) Last posting was on 2000-12-21 05:41:06.0Z
Ulises Posted on 2000-02-15 16:27:32.0Z
Newsgroups: sybase.public.easerver
From: "Ulises" <uloubrie@gmgw.com>
Subject: HTML Datawindow Jaguar and IIS ASP. Help Please
Date: Tue, 15 Feb 2000 09:27:32 -0700
Lines: 44
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: 204.131.108.118
Message-ID: <347_yhLClI9d$GA.332@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28649
Article PK: 160783

This is my second posting.
I hope I'm providing enough information this time. Please read the entire
message.

I configured one of the HTML Datawindow samples using jaguar 3.0, Powersite,
Personal Web Server successfully. The HTML has one header line and one
HTMLDatawindow only. :-)

I changed the deployment options on my Powersite project to generate the ASP
equivalent of my site.
Wen I execute my ASP page containing the Powersite generated code, I get the
error listed at the end of the post.

As far as I know, I followed all the steps required to register the Activex
Jaguar Server listed bellow, could someone please tell me what I missed?

1- I moved the pbvm70.dll, pbdwe70.dll, pbodb70.dll, pbsyc70.dll,
pbodb70.ini and pbdwr70.pbd to the Jaguar server Sybase\Shared\Powerbulder
directory.
2- Executed regsvr32.exe pbdwr70.dll
3- I Installed the Client software in the Jaguar Server even when IIS is in
the same server.
4- Copied the PDBWR70.TLB and PBDWR70.REG to the jaguar
../Sybase/Shared/Powerbuilder directory.
5- Changed the paths in PBDWR70.REG to ../Sybase/Shared/Powerbuilder.
6- Executed the .REG file.

I appreciate all your help. This is getting very frustrating.

ERROR:

Remote method invocation error '80020009'
Either the Metadata for methods of the component could not be read from the
NT Registry or the methods are using parameter types that are not presently
supported in the Jaguar ActiveX Proxy Server.
/webapps/ulises_project/ObjMod.js, line 580


Thanks
Ulises


Ulises Posted on 2000-02-16 14:56:17.0Z
Newsgroups: sybase.public.easerver
From: "Ulises" <uloubrie@gmgw.com>
Subject: Re: HTML Datawindow Jaguar and IIS ASP. Help Please
Date: Wed, 16 Feb 2000 07:56:17 -0700
Lines: 169
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: 204.131.108.118
Message-ID: <347_YaViR6Ie$GA.184@forums.sybase.com>
References: <347_yhLClI9d$GA.332@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28579
Article PK: 160723

More information regarding this issue:

I have the jagproxy.dll in multiple directories in the Jaguar / IIS Server.

Program Files\Sybase\Jaguar CTS 3.0\client\dll 106KB 3/18/99.
Program Files\Sybase\Jaguar CTS 3.0\client\dll\debug 185KB 3/18/99.
Program Files\Sybase\Jaguar CTS 3.0\dll 106KB 3/18/99.
Program Files\Sybase\Jaguar CTS 3.0\dll\debug 185KB 3/18/99.

I did not execute anything that "modified" this DLL, I think.

Here is the ASP Script:

<%@ LANGUAGE=JavaScript %>
<!--#INCLUDE VIRTUAL="/webapps/ulises_project/ObjMod.js"-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE></TITLE>
<META content="text/html; charset=windows-1252"
http-equiv="Content-Type">
<META name=GENERATOR content="MSHTML 5.00.2314.1000">
</HEAD>
<BODY>
<P>Oracle PowerSite</P>
<P>
<!--METADATA TYPE="DesignerControl" startspan
<OBJECT id=OBJECT1 name=htmlDW style="HEIGHT: 440px; WIDTH: 655px"
classid="CLSID:C77CAE91-7F08-11D2-BF7B-00C04F79FC8E">
<PARAM VALUE="D:\PBApps\PB7Web\TestHTMLDW\test_htmldw.pbl"
NAME=SourceFileName></PARAM>
<PARAM VALUE="d_ulises2_htmldw" NAME=DataWindowObject></PARAM>
<PARAM VALUE="" NAME=StandaloneDataWindow></PARAM>
<PARAM VALUE=0 NAME=AbsoluteLibPath></PARAM>
<PARAM VALUE=GMAlphaODBC NAME=DataConnection></PARAM>
<PARAM VALUE=0 NAME=EnableWeightSettings></PARAM>
<PARAM VALUE=0 NAME=EnableNameOverride></PARAM>
<PARAM VALUE=0 NAME=EnableRowsOverride></PARAM>
<PARAM VALUE=0 NAME=AllowDataEntry></PARAM>
<PARAM VALUE=0 NAME=Events></PARAM>
<PARAM VALUE=0 NAME=Validation></PARAM>
<PARAM VALUE=0 NAME=Formatting></PARAM>
<PARAM VALUE=0 NAME=Scripting></PARAM>
<PARAM VALUE=0 NAME=ServerStateManagement></PARAM>
<PARAM VALUE=htmlDW NAME=Name></PARAM>
<PARAM VALUE=0 NAME=PageSize></PARAM>
<PARAM VALUE="" NAME=RetrievalArgValues></PARAM>
<PARAM VALUE="" NAME=PageParameters></PARAM>
<PARAM VALUE="" NAME=ColumnLink></PARAM>
<PARAM VALUE="" NAME=ColumnLinkTarget></PARAM>
<PARAM VALUE="" NAME=UserPageParameters></PARAM>
<PARAM VALUE="corpweb1:9000" NAME=ServerName></PARAM>
<PARAM VALUE=jagadmin NAME=UserID></PARAM>
<PARAM VALUE="" NAME=Passwd></PARAM>
<PARAM VALUE="DataWindow/HTMLGenerator" NAME=ComponentName></PARAM>
<PARAM VALUE=0 NAME=OneTrip></PARAM>
<PARAM VALUE=1 NAME=EnableJaguar></PARAM>




</OBJECT>
-->
<%
jagConn = new PSJaguarConnection("corpweb1:9000", "jagadmin", "",
"DataWindow/HTMLGenerator", false);
dwSource = new PSDataWindowSourceClass("test_htmldw.pbl",
"d_ulises2_htmldw");
dbConn = new PSConnectionParmsClass("ConnectString='DSN=Alpha GM
ODBC;SERVER=cfmsrd;;UID=gm;PWD=adivino',ConnectOption='SQL_DRIVER_CONNECT,SQ
L_DRIVER_NOPROMPT'");
dwMine = new PSDataWindowClass("htmlDW", false, jagConn, dwSource, dbConn);
dwMine.Generate();
%>
<!--METADATA TYPE="DesignerControl" endspan-->
</P>
</BODY>
</HTML>

----------------------
I re-started Jaguar and requested the ASP page.
Bellow is the content of the srv.log
It shows a JDBC error, interesting, but my connection is ODBC.

Feb 16 07:52:47 2000: Listener # 1: Jaguar_tds: Active: yes Protocol:
'TDS': 'localhost',7878 Security Profile: '*NONE*'
Feb 16 07:52:47 2000: Listener # 2: Jaguar_OpenServer: Active: yes
Protocol: 'TDS': 'localhost',7979 Security Profile: '*NONE*'
Feb 16 07:52:47 2000: Listener # 3: Jaguar_http: Active: yes Protocol:
'HTTP': 'localhost',8080 Security Profile: '*NONE*'
Feb 16 07:52:47 2000: Listener # 4: Jaguar_https1: Active: yes Protocol:
'HTTPS': 'localhost',8081 Security Profile: 'sybpks_intl'
Subject DN: CN = Sample1, O = Some Organization, L = Some Locality, ST =
Some State, C = US
Feb 16 07:52:47 2000: Listener # 5: Jaguar_https2: Active: yes Protocol:
'HTTPS': 'localhost',8082 Security Profile: 'sybpks_intl_mutual_auth'
Subject DN: CN = Sample2, O = Some Organization, L = Some Locality, ST =
Some State, C = US
Feb 16 07:52:47 2000: Listener # 6: Jaguar_iiop: Active: yes Protocol:
'IIOP': 'localhost',9000 Security Profile: '*NONE*'
Feb 16 07:52:47 2000: Listener # 7: Jaguar_iiops1: Active: yes Protocol:
'IIOPS': 'localhost',9001 Security Profile: 'sybpks_intl'
Subject DN: CN = Sample1, O = Some Organization, L = Some Locality, ST =
Some State, C = US
Feb 16 07:52:47 2000: Listener # 8: Jaguar_iiops2: Active: yes Protocol:
'IIOPS': 'localhost',9002 Security Profile: 'sybpks_intl_mutual_auth'
Subject DN: CN = Sample2, O = Some Organization, L = Some Locality, ST =
Some State, C = US
Feb 16 07:52:47 2000: Listener # 9: Jaguar_iiop1: Active: yes Protocol:
'IIOP': 'CORPWEB1',9000 Security Profile: '*NONE*'
Feb 16 07:52:47 2000: Warning: DLL name is different, using previous name
Feb 16 07:52:47 2000: Warning: DLL name is different, using previous name
Feb 16 07:52:47 2000: Warning: DLL name is different, using previous name
Feb 16 07:52:47 2000: Starting Jaguar CTS 3.0
Feb 16 07:52:47 2000: Java JIT Compiler disabled
Feb 16 07:52:47 2000: Java component debugging disabled
Feb 16 07:52:47 2000: Java virtual machine initialized (version 10001)
Feb 16 07:52:48 2000: Repository: C:\Program Files\Sybase\Jaguar CTS
3.0\Repository
Feb 16 07:52:48 2000: Server's native codeset is iso_1
Feb 16 07:52:48 2000: NameServiceURL: iiop://0:0
Feb 16 07:52:48 2000: Starting services...
Feb 16 07:52:48 2000: Authentication timeout period is 3600 seconds.
Feb 16 07:52:48 2000: Note: authentication timeout can be disabled.
Feb 16 07:52:48 2000: Authentication lockout period is 600 seconds.
Feb 16 07:52:48 2000: Note: authentication lockout can be disabled.
Feb 16 07:52:48 2000: Started: Jaguar/Repository
Feb 16 07:52:48 2000: Started: Jaguar/GarbageCollector
Feb 16 07:52:49 2000: Started: Jaguar/JCM
Feb 16 07:52:49 2000: Starting Jaguar Naming Services...
Feb 16 07:52:49 2000: Started: CosNaming/NamingContext
Feb 16 07:52:49 2000: Started: CtsServlet/ServletService
Feb 16 07:52:49 2000: Loading: C:\Program Files\Sybase\Jaguar CTS
3.0\java\classes\surfsidevideo\CleanupServiceImpl.class
Feb 16 07:52:49 2000: Loading: C:\Program Files\Sybase\Jaguar CTS
3.0\java\classes\surfsidevideo\_sk_SurfSideVideoPJ_CleanupService.class
Feb 16 07:52:49 2000: Loading: C:\Program Files\Sybase\Jaguar CTS
3.0\java\classes\surfsidevideo\CleanupImpl.class
Feb 16 07:52:49 2000: Loading: C:\Program Files\Sybase\Jaguar CTS
3.0\java\classes\surfsidevideo\_sk_SurfSideVideoPJ_Cleanup.class
Feb 16 07:52:49 2000: Started: SurfSideVideoPJ/CleanupService
Feb 16 07:52:49 2000: Running services...
Feb 16 07:52:49 2000: Running: CosNaming/NamingContext
Feb 16 07:52:49 2000: Running: Jaguar/GarbageCollector
Feb 16 07:52:49 2000: Running: CtsServlet/ServletService
Feb 16 07:52:49 2000: Running: SurfSideVideoPJ/CleanupService
Feb 16 07:52:50 2000: Stopped: CosNaming/NamingContext
Feb 16 07:52:53 2000: SQLException after JDBC getConnection():JZ006: Caught
IOException: java.net.ConnectException: Connection refused

>
>ERROR:
>
>Remote method invocation error '80020009'
>Either the Metadata for methods of the component could not be read from the
>NT Registry or the methods are using parameter types that are not presently
>supported in the Jaguar ActiveX Proxy Server.
>/webapps/ulises_project/ObjMod.js, line 580
>
>
>Thanks
>Ulises
>
>
>
>


eugene.sicat Posted on 2000-12-21 05:41:06.0Z
Newsgroups: sybase.public.easerver
From: eugene.sicat@ptex.enbridge.com
Date: Thu, 21 Dec 2000 00:41:06 -0500
Subject: Re: HTML Datawindow Jaguar and IIS ASP. Help Please
Lines: 2
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <347_FCD554C52D359771001F3A82852569BC.0055CC9285256887@webforums>
References: <347_yhLClI9d$GA.332@forums.sybase.com> <347_YaViR6Ie$GA.184@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.easerver:3843
Article PK: 133164

I am having the same problem. Were you able to get the solution on this?
I would appreciate any input from anybody. Thanks.