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.

Jaguar, PB7 & A

4 posts in General Discussion (old) Last posting was on 2000-03-23 22:28:55.0Z
Borre Nordbakken Posted on 2000-03-23 11:57:44.0Z
Newsgroups: sybase.public.easerver
From: "Borre Nordbakken" <bno@brreg.no>
Subject: Jaguar, PB7 & A
Date: Thu, 23 Mar 2000 12:57:44 +0100
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: 193.161.193.254
Message-ID: <347_rshXD$Ll$GA.285@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:3435
Article PK: 132757

SQLCA.DBMS = "SYJ Adaptive Server Enterprise"
SQLCA.DBParm =
"UseContextObject='no',CacheName='xml_prod',Host='jagu',AppName='motorvogn'"
SQLCA.Database = "lqsdb"

When type:
sp_who
the host and appname is missing from the list
This only appaers from when jaguar makes connect to ASE
From an PB app using Open Client it looks correct

Any ideas

--
Borre


Borre Nordbakken Posted on 2000-03-23 22:28:55.0Z
Newsgroups: sybase.public.easerver
From: "Borre Nordbakken" <bno@brreg.no>
Subject: Re: Jaguar, PB7 & A
Date: Thu, 23 Mar 2000 23:28:55 +0100
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
NNTP-Posting-Host: port24.brsund-pm3-1.eunet.no 193.75.112.120
Message-ID: <347_sqIZFgRl$GA.34@forums.sybase.com>
References: <347_rshXD$Ll$GA.285@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:3432
Article PK: 132752

So, the best way to do it for me as a workaround is to use i.e. another
username when the connection pool
makes connections to the database from Jaguar.


--
Borre

"Borre Nordbakken" <bno@brreg.no> wrote in message
news:rshXD$Ll$GA.285@forums.sybase.com...
> SQLCA.DBMS = "SYJ Adaptive Server Enterprise"
> SQLCA.DBParm =
>
"UseContextObject='no',CacheName='xml_prod',Host='jagu',AppName='motorvogn'"
> SQLCA.Database = "lqsdb"
>
> When type:
> sp_who
> the host and appname is missing from the list
> This only appaers from when jaguar makes connect to ASE
> From an PB app using Open Client it looks correct
>
> Any ideas
>
> --
> Borre
>
>
>


Bill Green[TeamSybase] Posted on 2000-03-23 15:31:16.0Z
Newsgroups: sybase.public.easerver
Date: Thu, 23 Mar 2000 10:31:16 -0500
From: "Bill Green[TeamSybase]" <bill.green@teamsybase.com>
Reply-To: bill.green@teamsybase.com
Organization: TeamSybase
X-Mailer: Mozilla 4.6 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Jaguar, PB7 & A
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 32
NNTP-Posting-Host: threshold3.jpmorgan.com 169.71.1.12
Message-ID: <347_38DA38C4.AB8CC53B@teamsybase.com>
References: <347_rshXD$Ll$GA.285@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:3434
Article PK: 132755

If you have database connection pooling turned on, then the connections are
established for you way before you actually do the connect. Jaguar is using some
default connection stuff (setup in your connection cache) to make the
connections ahead of time. I'm not sure if there's a workaround while still
using connection pooling.

regards,
Bill

Borre Nordbakken wrote:

> SQLCA.DBMS = "SYJ Adaptive Server Enterprise"
> SQLCA.DBParm =
> "UseContextObject='no',CacheName='xml_prod',Host='jagu',AppName='motorvogn'"
> SQLCA.Database = "lqsdb"
>
> When type:
> sp_who
> the host and appname is missing from the list
> This only appaers from when jaguar makes connect to ASE
> From an PB app using Open Client it looks correct
>
> Any ideas
>
> --
> Borre

--
Bill Green[TeamSybase]

-----------------------------------------------------------
Good Links to know, good places to go:

Sybase Developer Network (SDN) - http://www.sybase.com/sdn
Find things like:
-- Print to PDF component
-- Lotus Notes E-Mail component
-- Taking existing PB apps to the web white paper

PFC Guide - http://www.pfcguide.com
Power3 - Custom Training - http://www.power3.com
-----------------------------------------------------------


Jim O'Neil [Sybase] Posted on 2000-03-23 16:21:06.0Z
Newsgroups: sybase.public.easerver
Date: Thu, 23 Mar 2000 11:21:06 -0500
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Jaguar, PB7 & A
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 70
NNTP-Posting-Host: joneil-nt.sybase.com 204.167.42.111
Message-ID: <347_38DA4472.D0E179C1@sybase.com>
References: <347_rshXD$Ll$GA.285@forums.sybase.com> <347_38DA38C4.AB8CC53B@teamsybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:3433
Article PK: 132753


"Bill Green[TeamSybase]" wrote:

> If you have database connection pooling turned on, then the connections are
> established for you way before you actually do the connect. Jaguar is using some
> default connection stuff (setup in your connection cache) to make the
> connections ahead of time. I'm not sure if there's a workaround while still
> using connection pooling.
>
> regards,
> Bill
>
> Borre Nordbakken wrote:
>
> > SQLCA.DBMS = "SYJ Adaptive Server Enterprise"
> > SQLCA.DBParm =
> > "UseContextObject='no',CacheName='xml_prod',Host='jagu',AppName='motorvogn'"
> > SQLCA.Database = "lqsdb"
> >
> > When type:
> > sp_who
> > the host and appname is missing from the list
> > This only appaers from when jaguar makes connect to ASE
> > From an PB app using Open Client it looks correct
> >
> > Any ideas
> >
> > --
> > Borre
>
> --
> Bill Green[TeamSybase]
>
> -----------------------------------------------------------
> Good Links to know, good places to go:
>
> Sybase Developer Network (SDN) - http://www.sybase.com/sdn
> Find things like:
> -- Print to PDF component
> -- Lotus Notes E-Mail component
> -- Taking existing PB apps to the web white paper
>
> PFC Guide - http://www.pfcguide.com
> Power3 - Custom Training - http://www.power3.com
> -----------------------------------------------------------

Oh now I get the question. Bill's right many of the DBParms don't take effect
because they need to be set before the connection takes place and since Jaguar is
making the actual physical connection, those DBParm settings are basically ignored.
The 7.0.1 readme has the following to say about DBParms when using SYJ:

SYJ Adaptive Server Enterprise
------------------------------
The SYJ Adaptive Server Enterprise database interface for Jaguar components supports
only those DBParms relevant at runtime. It does not support any design time
parameters since SYJ provides connectivity to ASE 11.5 for a PB custom class user
object that has been deployed as a Jaguar component. The following DBParms, which
are included on the SYJ Profile Setup dialog box, are not supported by SYJ:

- All the DBParms on the Regional Settings tab including CharSet, Language, Locale,
and UTF8 (for Unicode)

- All the Directory services DBParms on the Directory Services tab

- All the Security services DBParms on the Security tab

- All the DBParms on the Network tab including AppName, Host, MaxConnect,
PacketSize, and PWEncrypt

- The Release DBParm on the Connection tab

- The TableCriteria DBParm on the System tab

- The Asynchronous Operations DBParms, Async and DBGetTime, on the Transaction tab


--
Jim O'Neil
Senior Technical Support Engineer
Sybase, Inc