Hi Chen May;

  If this is for PowerServer version 2020 or below - have you tried the native (recommended) ASE driver in PS instead of ODBC?

Regards ... Chris

Hi Chris,

I using PowerServer2021 beta 2.

Use below setting to connect database :-

SQLCA.dbms = 'ODBC'

SQLCA.dbparm = "ConnectString='DSN=xxx;UID=xxx;PWD=xxx'", driver='ase'

Below is my Connection-Cache.json :-

"Connections": [
    {
      "CacheName": "DEVK_KL_DEFDB",
      "ConnectionType": "Odbc",
      "Server": "",
      "Host": "",
      "Port": 0,
      "Database": "",
      "UserID": "",
      "Password": "",
      "MinPoolSize": 0,
      "MaxPoolSize": 100,
      "ConnectionTimeout": 15,
      "CommandTimeout": 30,
      "IsDynamicDbConnect": true,
      "OtherOptions": "",
      "EnablePooling": false,
      "ConnectionLifetime": 0,
      "OdbcName": "DEVK_KL_DEFDB",
      "DataSource": "",
      "OdbcDriver": "ASE"
    },

Hi Chen May;

  PS2021 is technically a "whole new ball game" compared to PS2020. I would like to suggest that you open a Support Ticket for this issue. Especially, since PS2021 is currently a "beta". This will allow our Appeon Engineering team to fully delve into your issue. It could be something new that PS2021 was not anticipating. Of course, that is what a Beta is design to do ... expose these anomalies. Many thanks in advance!

Regards ... Chris