Hi,
I using PowerServer2021 beta 2.
Use below setting to connect Sybase 15.5 worked fine in development server :-
SQLCA.dbms = 'ODBC'
SQLCA.dbparm = "ConnectString='DSN=xxx;UID=xxx;PWD=xxx'", driver='ase'
But when connect from end-user PC below error return :-
R0222 - Applicatoin terminated. Error : Cannot connect to the server when creating the session.
Can we install ODBC ASE driver and setup ODBC connection in end-user PC during installation ? Like downloading the Laucher and start the application .
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"
},
Now used PB2021 beta 2database configure PowerServer.Web APIs->database configuration.
I have changed the connection-cache.json follow AEM setting as below but not working :-
"CacheName": "DEVK_KL_DEFDB",
"ConnectionType": "ASE",
"Server": "DEVK",
"Host": "10.203.29.16",
"Port": 3001,
"Database": "KL_DEFDB",
"UserID": "xxxxx",
"Password": "YeeMoi01$",
"MinPoolSize": 10,
"MaxPoolSize": 100,
"ConnectionTimeout": 15,
"CommandTimeout": 30,
"IsDynamicDbConnect": true,
"OtherOptions": "",
"EnablePooling": true,
"ConnectionLifetime": 0,
"OdbcName": "",
"DataSource": "",
"OdbcDriver": ""
}