Introduction to sqlanydb

The SQL Anywhere Python database interface, sqlanydb, is a data access API for the Python language. The Python Database API specification defines a set of methods that provides a consistent database interface independent of the actual database being used. Using the sqlanydb module, your Python scripts have direct access to SQL Anywhere database servers.

The sqlanydb module implements, with extensions, the Python Database API specification v2.0 written by Marc-André Lemburg. Once you have installed the sqlanydb module, you can access and change the information in SQL Anywhere databases from Python.

For information about the Python Database API specification v2.0, see [external link] http://www.python.org/dev/peps/pep-0249/.

The sqlanydb module is thread-safe when using Python with threads.

Requirements

The sqlanydb module requires the following components.

Python is required. For a list of supported versions, see http://www.sybase.com/detail?id=1068981.

The ctypes module is required. To test if the ctypes module is present, open a command prompt window and run Python.

At the Python prompt, enter the following statement.

import ctypes

If you see an error message, then ctypes is not present. The following is an example.

>>> import ctypes
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
ImportError: No module named ctypes

If ctypes is not included in your Python installation, install it. Installs can be found in the SourceForge.net files section at [external link] http://sourceforge.net/project/showfiles.php?group_id=71702.

Peak EasyInstall also installs ctypes. To download Peak EasyInstall, go to [external link] http://peak.telecommunity.com/DevCenter/EasyInstall.

Discuss this page in DocCommentXchange.