- Clarence Chamorro
- PowerServer 2020 or older (Obsolete)
- Sunday, 14 October 2018 12:15 PM UTC
Good morning,
I have an issue. It could be because my no much experience with PowerServer. He it goes:
Why is it if I have PowerServer Data Source Dynamic Database Connection turn off the apps connect to the database performance is supppppeeerrr fassssttttt. Vrs if I have the Data Source Dynamic Database Connection turn on the apps connection to the database performance is super slow?
This is my actual connection code:
//cch if it is window's client
If AppeonGetClientType() = 'PB' Then
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=arazoza_prod17;UID=;PWD=;UID=" + Trim(istr_gen.username) + ";PWD="+ Trim(istr_gen.userpassword) +"',cachename='arazoza_prod17'"
Else
//cch if is mobile or web's client
SQLCA.DBMS = "ODB-asa"
SQLCA.AutoCommit = False
SQLCA.DBParm = "cachename = 'arazoza_prod17'"
SQLCA.LogId = Trim(istr_gen.username)
SQLCA.LogPass=Trim(istr_gen.userpassword)
End If
do I have to add any other parameter so it connect as fast as if I have the Data Source Dynamic Database Connection turn of.
Like always regretful of your help.
Regards,
Clarence.
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.