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, is possible to use sqlalchemy-sqlany with python 3.3? It would be wonderful if it is possible. Particularly I need to use it with pyramid framework and few other dependencies that require python 3.

Updated Thanks a lot for quick response. Maybe I am not using it correctly, here what I get when try to connect:

Python 3.3.0 (v3.3.0:bd8afb90ebf2, Sep 29 2012, 01:25:11) 
[GCC 4.2.1 (Apple Inc. build 5666) (dot 3)] on darwin 
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlalchemy
>>> from sqlalchemy import create_engine
>>> from sqlalchemy.dialects import registry
>>> registry.register('sqlalchemy_sqlany', 'sqlalchemy_sqlany.base', 'SQLAnyDialect')
>>> engine = create_engine('sqlalchemy_sqlany://admin:admin@', echo=True)
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/Users/athli/Devel/jesse/ChartPoint/pyramid/lib/python3.3/site-packages/SQLAlchemy-0.8.0-py3.3.egg/sqlalchemy/engine/", line 332, in create_engine
return strategy.create(*args, **kwargs)
File "/Users/athli/Devel/jesse/ChartPoint/pyramid/lib/python3.3/site-packages/SQLAlchemy-0.8.0-py3.3.egg/sqlalchemy/engine/", line 50, in create
dialect_cls = u.get_dialect()
File "/Users/athli/Devel/jesse/ChartPoint/pyramid/lib/python3.3/site-packages/SQLAlchemy-0.8.0-py3.3.egg/sqlalchemy/engine/", line 107, in get_dialect
cls = registry.load(name)
File "/Users/athli/Devel/jesse/ChartPoint/pyramid/lib/python3.3/site-packages/SQLAlchemy-0.8.0-py3.3.egg/sqlalchemy/util/", line 91, in load
return self.impls[name]()
File "/Users/athli/Devel/jesse/ChartPoint/pyramid/lib/python3.3/site-packages/SQLAlchemy-0.8.0-py3.3.egg/sqlalchemy/util/", line 116, in load
mod = __import__(modulepath)
File "/Users/athli/Devel/jesse/ChartPoint/pyramid/lib/python3.3/site-packages/sqlalchemy_sqlany/", line 11, in <module>
ImportError: No module named 'base'

asked 11 Jun '14, 12:40

jarda_kotesovec's gravatar image

accept rate: 0%

edited 09 Oct '14, 14:48

Graeme%20Perrow's gravatar image

Graeme Perrow

The SQLAlchemy driver currently only supports Python 2.x. I will investigate adding Python 3 support, but I have no estimate for when this might happen.

Version 1.0.1 of the sqlalchemy-sqlany driver has been posted. This version has been tested with Python 3.4. It requires version 1.0.6 of the sqlanydb python driver, also posted today.

permanent link

answered 12 Jun '14, 12:37

Graeme%20Perrow's gravatar image

Graeme Perrow
accept rate: 54%

edited 26 Jun '14, 15:15

Graeme, thanks a lot for looking into it. Very appreciated.

(13 Jun '14, 03:42) jarda_kotesovec

Thanks a lot!

(12 Sep '14, 15:18) jarda_kotesovec
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: 11 Jun '14, 12:40

question was seen: 4,198 times

last updated: 09 Oct '14, 14:48