Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Hi. We create software with PowerBuilder to run against SQLA. We seem to have found that when our developer's copy of SQLA is more than a few versions ahead of our customer's copy of SQLA, problems may develop. For instance, our developers now develop with PB12 against SQLA12. Customers who are running SQLA8 are (depending on the app functions they use) likely to have (what are often) subtle problems which are eliminated, if they upgrade SQLA. At the moment, it seems our customers who are running SQLA9 and above, are fine. Is there any way to know the minimum SQLA versions our customers need to be running?

asked 18 Jun '12, 12:12

dejstone's gravatar image

accept rate: 0%


There is no gear to determine the minimum SQL Anywhere versions requirements for an application. We do document new features and behaviour difference to highlight changes that could impact an implementation. Testing is needed to verify that any specific version of SQL Anywhere is suited for a particular application.

For context, what specifically are the subtle problem(s) your customers are seeing. And what version and build are being used when the problems are seen?

(18 Jun '12, 13:23) Chris Keating

Basically you have two choices.

  1. Develop your application against oldest version your customers have and test it against all SA versions you are willing to support.
  2. Choose some SA version and tell your customers that they'll need that version to run your program.
permanent link

answered 19 Jun '12, 05:00

Dmitri's gravatar image

accept rate: 11%


We do something like 2: we always support 3 versions of SA (currently 10,11,12). Our customers may use their older versions as long as they please, but that might not be compatible with the current version of our software.

(19 Jun '12, 07:13) Reimer Pods

FWIW each deployed version of Foxhound requires a certain minimum version AND build of SQL Anywhere to run on. Target databases can run on anything from 5.5 and up, but not Foxhound itself... it won't even start. The whole idea of testing multiple combinations of older versions gives me the heebie jeebies, let alone trying to support untested combinations. So far (touch wood) allowing newer-than-minimum versions of SQL Anywhere hasn't resulted in any trouble reports.

(19 Jun '12, 09:08) Breck Carter
Replies hidden

Yes, checking "@@select version" at program setup (and/or at program start) and stop with an according message if the installed SQ version doesn't meet the (minimum) requirements is our preferred behaviour, as well...

(19 Jun '12, 09:16) Volker Barth
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: 18 Jun '12, 12:12

question was seen: 2,440 times

last updated: 19 Jun '12, 09:16