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.

Appeon and the HOST variable in MS SQL

2 posts in Appeon (partner product) Last posting was on 2012-12-06 07:47:07.0Z
Jorge Ramírez - IASACORP INTERNATIONAL Posted on 2012-11-12 13:59:24.0Z
Sender: 37a6.50a0ff47.1804289383@sybase.com
From: Jorge Ramírez - IASACORP INTERNATIONAL
Newsgroups: sybase.public.appeon
Subject: Appeon and the HOST variable in MS SQL
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50a100bc.37fc.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 12 Nov 2012 05:59:24 -0800
X-Trace: forums-1-dub 1352728764 172.20.134.41 (12 Nov 2012 05:59:24 -0800)
X-Original-Trace: 12 Nov 2012 05:59:24 -0800, 172.20.134.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:3059
Article PK: 13723

Hello,

Appeon open a connection to SQL Server including the fixed
value "APPEONDEV" in the MS SQL Server connection string (in
Host variable).

Please I need to include the user name in the Host variable,
inside the Appeon connection string.

How I can do it?

Thank you for your responses

Regards,

Jorge Ramírez R.
Systems Department
IASACORP INTERNATIONAL S.A.
Lima - Perú


Steven Posted on 2012-12-06 07:47:07.0Z
Sender: 1a0c.50c0483a.1804289383@sybase.com
From: steven
Newsgroups: sybase.public.appeon
Subject: Re: Appeon and the HOST variable in MS SQL
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50c04d7b.1ac7.1681692777@sybase.com>
References: <50a100bc.37fc.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 5 Dec 2012 23:47:07 -0800
X-Trace: forums-1-dub 1354780027 172.20.134.41 (5 Dec 2012 23:47:07 -0800)
X-Original-Trace: 5 Dec 2012 23:47:07 -0800, 172.20.134.41
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:3066
Article PK: 1158165

Hi Jorge,

The all connection s was managed by the Appeon server under
B/S mode, and the hostname will always the name of Appeon
Server, and there is not a good way to work around it.
With Dynamic Database Connection, you can specify the logid
and logpass parameter of the transaction object in PB
script, so, if your PB application is using different logid
connect to the database, then you can use the logid for
validation.

Regards,
Steven