Hello, the Python DB-API 2.0 driver 'sqlanydb' for SQL Anywhere works fine and I'd like to use the SQLAlchemy connection pool within Pyramid. Unfortunately, SQLAlchemy doesn't let me use sqlanydb.
Actually, I don't need any ORM stuff for the start, but if its required, the mssql dialect should be pretty close to SQL Anywhere. But using create_engine() with special connect_args for sqlanydb doesn't work and using the creator=<callback> parameter doesn't work either. I always get "No module named pyodbc" because the dialects mssql and sybase seem to default to pyodbc. Why isn't it possible to use just any DB-API compliant database driver? I also read a post which claimed, that until SQLAlchemy 0.5 there was a driver for sqlanydb included, but I couldn't find one in that release. It would be very bad if I had to resign from using SQLAlchemy, but I have no choice in the database driver. I'm also not that much into SQLAlchemy to write an own driver and dialect, but I'm happy to run a test suite on a current SQL Anywhere database if someone else does. Kind regards Marten -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/19fdkEbEB_AJ. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.