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.

Dynamically choose database

3 posts in Appeon (partner product) Last posting was on 2011-01-12 07:05:37.0Z
Daniel Jenkins Posted on 2011-01-04 11:49:35.0Z
From: Daniel Jenkins <danieldotjenkins@gmail.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-GB; rv:1.9.2.13) Gecko/20101207 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.appeon
Subject: Dynamically choose database
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d23094f@forums-1-dub>
Date: 4 Jan 2011 03:49:35 -0800
X-Trace: forums-1-dub 1294141775 10.22.241.152 (4 Jan 2011 03:49:35 -0800)
X-Original-Trace: 4 Jan 2011 03:49:35 -0800, vip152.sybase.com
Lines: 40
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2623
Article PK: 13522

Hi,

PB 12.1.6518 / ASE 12.5.1 & open client SYC / Appeon 6.5

I am new to Appeon and request some assistance.

I have a C/S app that allows the user to select the DB to connect to at
login time. I build the SQLCA properties based on the users' choice.

I have been trying to get this part of the Appeon Server Configuration
Guide to work - to no avail:

Quote
Dynamic transaction object to connection cache mapping
Transaction object to connection cache mapping can be dynamically set up
or changed by
setting or changing the DBMS and DBParm properties of the Transaction
object in the
application source code.
To set or change the connection cache dynamically, code the DBParm
property of the
Transaction object in this format:
SQLCA.DBParm=“CacheName='ASAConnectionCache1'”
End Quote

In spite of changing the CacheName property based on users' choice, the
app always connects to the connection cache specified in my transaction
object in Appeon Enterprise Manager.

I also enabled 'Dynamic Database Connection' on both connection caches
but no dice.

Any help appreciated.

Daniel.


Steven Posted on 2011-01-05 09:34:05.0Z
Sender: 35f6.4d2284bb.1804289383@sybase.com
From: steven
Newsgroups: sybase.public.appeon
Subject: Re: Dynamically choose database
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d243b0d.2a04.1681692777@sybase.com>
References: <4d23094f@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 5 Jan 2011 01:34:05 -0800
X-Trace: forums-1-dub 1294220045 10.22.241.41 (5 Jan 2011 01:34:05 -0800)
X-Original-Trace: 5 Jan 2011 01:34:05 -0800, 10.22.241.41
Lines: 42
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2625
Article PK: 21791

Hi Daniel,

Let me explain Appeon database connection mechanism a little
bit. Unlike PowerBuilder's direct database connection,
Appeon uses connection cache to connect to the database.
Besides, you have to pre-configure database host and
database name and port that are used to connect to the
database.

SQLCA.DBMS = "SYC" //This property corresponds to the
Connection Type of Connection Cache.
SQLCA.LogPass = "appeon" // This property corresponds to the
password of Connection Cache. And if you set dynamic
database connection of connection cache property is on in
the Appeon for .NET version, Appeon can support Logid and
logpass of transaction property. For example, sqlca.logid =
sle_1.text; sqlca.logpass=sle_2.text.
SQLCA.LogId = "sa" // This property corresponds to the user
name of Connection Cache.
SQLCA.AutoCommit = False
SQLCA.DBParm = "rELEASE='12.5'"
SQLCA.DATABASE = ''
SQLCA.SERVERNAME= ''
// This property corresponds to the ODBC Data Source of
Connection Cache.

Connection Cache Name: appeonsample
Connection Type:
ODBC Data Source:
Database Host:
Database Port:
Database Name:
User Name:
Password:

According to your settings, your configuration was right. So
could you provide AppeonServer.log and AppeonError.log.
Please clear the log files first, set the Log mode to Debug,
and then reproduce the issue on the Web.

Regards,
Steven


Daniel Jenkins Posted on 2011-01-12 07:05:37.0Z
From: Daniel Jenkins <danieldotjenkins@gmail.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-GB; rv:1.9.2.13) Gecko/20101207 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.appeon
Subject: Re: Dynamically choose database
References: <4d23094f@forums-1-dub> <4d243b0d.2a04.1681692777@sybase.com>
In-Reply-To: <4d243b0d.2a04.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d2d52c1@forums-1-dub>
Date: 11 Jan 2011 23:05:37 -0800
X-Trace: forums-1-dub 1294815937 10.22.241.152 (11 Jan 2011 23:05:37 -0800)
X-Original-Trace: 11 Jan 2011 23:05:37 -0800, vip152.sybase.com
Lines: 54
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2628
Article PK: 13521

Hi Steven,

Thank you for your reply. I am pretty busy with something else right now
but as soon as I have a chance to get back to trying Appeon I'll post
the log files (I just checked and both are blank!)

Regards,

Daniel.

On 05/01/2011 13:34, steven wrote:
> Hi Daniel,
>
> Let me explain Appeon database connection mechanism a little
> bit. Unlike PowerBuilder's direct database connection,
> Appeon uses connection cache to connect to the database.
> Besides, you have to pre-configure database host and
> database name and port that are used to connect to the
> database.
>
> SQLCA.DBMS = "SYC" //This property corresponds to the
> Connection Type of Connection Cache.
> SQLCA.LogPass = "appeon" // This property corresponds to the
> password of Connection Cache. And if you set dynamic
> database connection of connection cache property is on in
> the Appeon for .NET version, Appeon can support Logid and
> logpass of transaction property. For example, sqlca.logid =
> sle_1.text; sqlca.logpass=sle_2.text.
> SQLCA.LogId = "sa" // This property corresponds to the user
> name of Connection Cache.
> SQLCA.AutoCommit = False
> SQLCA.DBParm = "rELEASE='12.5'"
> SQLCA.DATABASE = ''
> SQLCA.SERVERNAME= ''
> // This property corresponds to the ODBC Data Source of
> Connection Cache.
>
> Connection Cache Name: appeonsample
> Connection Type:
> ODBC Data Source:
> Database Host:
> Database Port:
> Database Name:
> User Name:
> Password:
>
> According to your settings, your configuration was right. So
> could you provide AppeonServer.log and AppeonError.log.
> Please clear the log files first, set the Log mode to Debug,
> and then reproduce the issue on the Web.
>
> Regards,
> Steven