Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

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.

asked 02 Aug '23, 22:20

jun123's gravatar image

accept rate: 0%

edited 02 Oct '23, 15:52

Graeme%20Perrow's gravatar image

Graeme Perrow


In addition to John's answer, here's a link for SQL Anywhere 17:

The website 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...

(03 Aug '23, 03:54) Volker Barth

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.

permanent link

answered 02 Aug '23, 23:03

John%20Smirnios's gravatar image

John Smirnios
accept rate: 37%

Comment Text Removed
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 02 Aug '23, 22:20

question was seen: 502 times

last updated: 02 Oct '23, 15:52