- Randy Zaffke
- PowerBuilder
- Wednesday, 20 April 2022 04:35 PM UTC
hello
we have an application that is accessed via citrix
we are upgrading our database servers to Microsoft sql 2019 from 2012
apologies I am definitely NOT a database connection expert
historically our application INI file for connection would be as thus
and this still works fine on my desktop version of the application and from the powerbuilder environment itself.
[power]
DBMS='SNC'
Database='NbrPower'
Servername='wn000044139'
LogPassword=xxxxxxxxxxx
DBParm= "ProviderString='MARS Connection=false', trimspaces=1, RecheckRows=1"
logid=powerappuser
SQLCA.AutoCommit=false
LOGONMETHOD = 'NoPassword'
PBSupportBindSelect='NO'
PBSupportBindUpdate='NO'
PBSupportDBBind='NO'
"
however this is not working for the SQL 2019 server
we have also tried MSOLEDB as thus, this did not work, as database connection was never made
[power]
DBMS='MSOLEDBSQL'
Database='NbrPower'
Servername='44139'
LogPassword=xxxxxxxxxxx
DBParm= "TrustedConnection=1,ProviderString='MARS Connection=false', trimspaces=1, RecheckRows=1"
LOGONMETHOD = 'NoPassword'
logid=powerappuser
SQLCA.AutoCommit=false
PBSupportBindSelect='NO'
PBSupportBindUpdate='NO'
PBSupportDBBind='NO'
"
and we have tried ODBC like this
which has worked, almost, users can make connections but a user cannot have two instances of the application open at once, as they have using SNC, which is a requirement.
[power]
DBMS='ODBC'
Database=NbrPower
LogPass =xxxxxxxxxx
LogId ="powerappuser"
ServerName='44139'
AutoCommit=False
DBParm=ConnectString='DSN=Powerdev;UID=powerappuser;PWD=xxxxxxxxxx;TrustedConnection=1,ProviderString='MARS Connection=false''
we have on the citrix server installed OLE for SQL Server 19.0 and trusted connection is set to true
also the odbc connection is correct and tested
Citrix team and DQL DBA have confirmed correct ports are open and nothing is being blocked on either end.
firewall team has ensured this is open as well
thanks for any insight
Randy
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.