Hi Eric,
In PowerBuilder application (client/server), once the client establishes connection to the database, a unique session will be created in database and maps to the application session, this is so called long connection, so it's a one-to-one relationship. However on Web application (browser/server), it uses the connection cache to connect to the database, the client does not connect to DB server directly, and all connect cache are managed by the Appeon Server. one Appeon IE session maps to more than one session in the database; when data retrieval or procedure is executed, the cache pool will automatically allocate a connection to connect to the database. When transaction is completed, the connection will be rolled back to the cache pool, this is so called short connection. One Web application may have many transactions, so it's a one-to-many relationship.
Please try the long connection solution below to see if is satisfy your request. you can use db user id to identity session with this solution.
http://support.appeon.com/appeon/Long_Connection.doc
Regards,
Zhaoka
I first changed the data sources (server | resources | data source) in AEM.
Datasourcetype: ODBC driver
ODBC Data Source: PigExpert
Maximum connection pool size: 1
Minimum connection pool size: 1
Connection timeout (seconds) : 120
Command timeout (seconds): 30
Connection Lifetime (seconds): 0
Dynamic Database connection: On checked
Pooling: On checked
In Powerserver there is also a tab "DB settings". So, now I have 3 settings.
The first in our programm, in AEM and in Powerserver. Where are these settings saved?
Problem is that in "PowerServer toolkit | DB Settings | Transaction object" the User name and Password change to 21 and ** after a full application deployment.
Please use the script like below to specify the user/password to connect to the database.
SQLCA.LogId = %your id%
SQLCA.LogPass=%your pass%
Regards,
ZhaoKai