Thank you for your response.
1. The SQLCA connection settings that your PB App is using
After getting information from Login window:
SQLCA.ServerName = <getting server name here>
SQLCA.Database = <getting database name here>
SQLCA.LogId = <getting user ID text here>
SQLCA.LogPass = <getting user password text here>
Then I use Connect using SQLCA ;
2) After the CONNECT; command the DBMS return code and error text returned by the DBMS
I use Message.DoubleParm to connect database , if Message.DoubleParm = 1 then Connect using SQLCA
After connection , check error using SQLCA.sqlcode <> 0
3) The results of an SQL trace from your App
When I login ,it’s fine , no error .
(07AB0008): LOGIN:
(07AB0008): SRV 10 #5701 Changed database context to 'xxxx'. (0.004 MS / 0.004 MS) (17.072 MS / 17.076 MS)
(07AB0008): CONNECT TO TRACE ASE ADAPTIVE SERVER ENTERPRISE:
(07AB0008): DATABASE=xxx database
(07AB0008): LOGID=xxxxxID
(07AB0008): SERVER=xxxx
(07AB0008): DBPARM=Host='xxxxx’
(07AB0008): SRV 10 #5701 Changed database context to 'xxxxx'. (0.001 MS / 17.077 MS) (0.623 MS / 17.700 MS)
(07AB0008): PREPARE: (0.001 MS / 17.701 MS)
DBMS on PB version 7
sqlca.dbms="SYC SYBASE System 10 CTLIB"
sqlca.dbparm = "release='11.0',async=1"
sqlca.autocommit= TRUE
DBMS set up on version 2019
SQLCA.DBMS = "ASE Adaptive Server Enterprise"
SQLCA.DBParm = "Release='16'"
SQLCA.AutoCommit = True