cancel
Showing results for 
Search instead for 
Did you mean: 

How do I find the maximum length for server hostname?

Former Member
3,862

I just inherited some legacy code that uses SQL Anywhere. The server name is truncated, whenever constructed, to 30 characters. This causes problems for some users. I want to find out if this is a SQLA limitation, but haven't found a definitive answer in last day of searching.

Accepted Solutions (0)

Answers (2)

Answers (2)

graeme_perrow
Advisor
Advisor

The limit was 40 bytes except for shared memory on unix, which was 31 bytes. This was bumped to 250 bytes in version 10.

Former Member

If my hazey memory recalls correctly versions prior to 10 restricted the length of the servername parameter. I think it was 40 bytes