- Ravi Nath
- PowerServer
- Thursday, 13 July 2023 04:44 PM UTC
Hi,
We have an app we are developing an app in Powerbuilder 2022 build 1900 where we set the app name in the database connection string when connecting to SQL Server 2019. We are using ODBC driver.
The issue is when we run the app like a regular Powerrbuilder desktop app it sets the app name correctly but when we deploy it to Powerserver it comes out as blank.
Is this a bug ? We need to be able to identify the connection by a user and so we set the name in there. We use a common login credential for connecting to db.
string ls_connectstring
sqlca.dbms = 'ODBC'
ls_connectstring = 'DSN=My SQL SERVER;UID='+ "xxxxxx"+';PWD=xxxxxx;app=User10'
sqlca.dbparm = "Connectstring='"+ls_connectstring+"'"
connect using sqlca ;
Thanks
Ravi Nath
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.