Sybase

Support for the Sybase database.

DBAPI Support

The following dialect/DBAPI options are available. Please refer to individual DBAPI sections for connect information.

Note

The Sybase dialect within SQLAlchemy is not currently supported. Thedialect is not tested within continuous integration and is likely to havemany issues and caveats not currently handled.

python-sybase

Support for the Sybase database via the Python-Sybase driver.

DBAPI

Documentation and download information (if applicable) for Python-Sybase is available at:http://python-sybase.sourceforge.net/

Connecting

Connect String:

  1. sybase+pysybase://<username>:<password>@<dsn>/[database name]

Unicode Support

The python-sybase driver does not appear to support non-ASCII strings of anykind at this time.

pyodbc

Support for the Sybase database via the PyODBC driver.

DBAPI

Documentation and download information (if applicable) for PyODBC is available at:http://pypi.python.org/pypi/pyodbc/

Connecting

Connect String:

  1. sybase+pyodbc://<username>:<password>@<dsnname>[/<database>]

Unicode Support

The pyodbc driver currently supports usage of these Sybase types withUnicode or multibyte strings:

  1. CHAR
  2. NCHAR
  3. NVARCHAR
  4. TEXT
  5. VARCHAR

Currently not supported are:

  1. UNICHAR
  2. UNITEXT
  3. UNIVARCHAR

mxodbc

Support for the Sybase database via the mxODBC driver.

DBAPI

Documentation and download information (if applicable) for mxODBC is available at:http://www.egenix.com/

Connecting

Connect String:

  1. sybase+mxodbc://<username>:<password>@<dsnname>

Note

This dialect is a stub only and is likely non functional at this time.