Many individuals and organizations use Adaptive Server Anywhere 7 (and its predecessors SQL Anywhere 5, Adaptive Server Anywhere 6) in the various MS Windows environments, and, because of this, there is considerable Adaptive Server Anywhere/SQL Anywhere documentation and commentary, in a Windows context.
However, Adaptive Server Anywhere is a multi platform product running on MS Windows, Novell NetWare, and UNIX. Consequently, some of our newsletter focus needs to reflect this fact.
With this in mind, this month's newsletter will shed some light on Adaptive Server Anywhere/SQL Anywhere, running on the UNIX platform. Specifically, we present the most up-to-date list of Frequently Asked Questions.
Introduction
Getting Started
Q1. Which versions of Unix are supported by SA/ASA?
Q2. Which O/S patches are required by SA/ASA?
Q3. How do I set up my environment to run ASA?
Installing SA/ASA
Q4. How much disk space is required?
Q5. How do I uninstall SA/ASA?
Q6. What are the minimum files required to run SA/ASA?
Q7. How do I get an upgrade or bug fix?
Q8. Where is the on-line help?
Using the Database Engine
Q9. What are the system resources needed by ASA?
Q10. Which engine switches are supported only on Unix?
Q11. Which engine switches are not supported on Unix?
Q12. Which ASA features are not supported on Unix?
Q13. Which ASA features are only supported on some Unix versions?
Q14. How should I shut down the server?
Q15. How do I port my database from Windows to Unix?
Q16. How do I connect to my server through the firewall?
Q17. Which ODBC driver manager should I use on Unix?
Q18. How do I use ASA with one or more of: Apache, PHP, perl, DBD and UnixODBC?
Common Problems and Error Messages
Q19. When trying to install ASA on Linux, I get "dbinstall: error in loading shared libraries: libstdc++.so: cannot open shared object file: No such file or directory
Q20. When trying to start a server, I get: Error in command near "x" followed by the usage screen.
Q21. The ALT key does not work in dbisql (or dbisqlc).
Q22. The function keys F1 to F10 do not work in dbisql (or dbisqlc).
Q23. On RedHat 7.0 or Mandrake Linux, dbisqlc fails to start, with the message "Unable to initialize screen routines:".
Q24. I can create a database with a very long name, but I cannot start an engine on it
Q25. How do I reduce the amount of data ASA places into my messages file?
Q26. ASA6 server on Linux with Win clients hanging during queries
Q27. Can I use SQL Remote under Unix?
Q28. Using PHP, and connecting to ASA via the Sybase ct-libraries. It appears that we can only connect to the first of several databases started on that server.
Q29. Have just installed ASA6 for Linux on pretty basic RedHat 6 setup and cannot start a database engine. I have added all the environment settings, such as path and shared library path. When trying to start dbeng6 or dbsrv6 the following error occurs: BUG IN DYNAMIC LINKER ld.so: dl-version.c: 210: _dl_check_map_versions: Assertion `needed != ((void *)0)' fail!
