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