I have recently inherited legacy code that utilizes SQL Anywhere. I noticed that the server name gets truncated to 30 characters whenever it is constructed, which is causing issues for certain users. To determine whether this limitation is specific to SQL Anywhere, I've been searching for a definitive answer, but haven't found one yet, despite a day of extensive searching. |
Hello, your question refers to "server hostname" but I think you are referring to SQLAnywhere server names rather than hostnames. Right? I can find references in the code to an "old" limit of 40 characters for a SQLA server name but the current limit is 250. The 40-character limit would have been very, very long ago. |
In addition to John's answer, here's a link for SQL Anywhere 17:
https://dcx.sap.com/index.html#sqla170/en/html/8147ccb36ce21014b123d6ff431d5722.html
The website https://dcx.sap.com/index.html hosts also documentatiion for older versions back to 10.0.1. The oder limit of 40 chars mentioned by John seems to go back to version 9 and below...