Symptom

When the PowerServer application uses ODBC to connect to the SQL Anywhere database and PowerServer Web API is published to IIS, if the database is on the same machine as the Web API, the PowerServer application may fail to connect to the database and SQLCA.SQLErrorText will return “Database Server not found.”


Environment

SQL Anywhere 12/16/17 or later

PowerServer 2021 or later

Windows IIS 


Cause

Using dbsrv##.exe to start the SQL Anywhere database will cause the .NET application to not be able to connect to the database by ODBC.

For example, dbsrv16.exe “C:\Users\Public\Documents\SQL Anywhere 16\Samples\demo.db”.


Resolution

You can use any of the solutions below to work around this issue:


Solution #1 – Start the SQL Anywhere database in a different way (recommended)

Instead of using dbsrv##.exe, create a service in Sybase Central to start the SQL Anywhere database, as shown in the screenshot below:


Solution #2 – Modify ODBC

On the login tab of the ODBC Configuration window, change Action from “Connect to a running database on this computer” to “Connect to a running database on another computer.”

Before the change:


After the change:


 

1
2