The SQL Anywhere database can be connected using the ODBC driver only for the PowerBuilder installable cloud app. You will need to configure the ODBC data source in both the PowerBuilder IDE and the server hosting PowerServer.
To configure ODBC for SQL Anywhere (using SQL Anywhere 17 as an example):
-
Install the ODBC driver of SQL Anywhere 17.
-
Open the ODBC Data Source Administrator (64-bit) tool (in the Windows search bar (or press Win + Q), type "ODBC" and then select ODBC Data Source (64-bit)). Only 64-bit ODBC data source is supported (32-bit is not supported.)
-
On the System DSN tab, click Add. In the Create New Data Source dialog, select SQL Anywhere 17 driver which was just installed, and then click Finish.
-
Create an ODBC data source by following the numerical order in the figure below. Remember to replace the database information with your own ones.