sqlalchemy and MS Access Database

[Fabio Caritas Barrionuevo da Luz]

Hello, I need to perform some tasks in a MS Access database (.mdb file). Currently, I can successfully connect to a MS Access database using pypyodbc[1] at CPython and IronPython interpreter in Windows 7 64bit.

I would like to migrate my RAW SQL solution that uses pypyodbc for a solution that uses sqlalchemy.

The question is, what should I do to be able to use sqlalchemy with a MS Access database?

Is there any functional sqlalchemy DIALECT (driver) for MS Access?

Some legacy systems use that database, then there is an option to change it to another database as SQLServer.

I tried running the tutorial of integration[2][3] that exists in pypyodbc the page, but I can not connect directly to the .mdb file, 

and not create the "ODBC data source" in Windows, because Windows does not just me of the option to create it

[1] https://code.google.com/p/pypyodbc/

[2] https://code.google.com/p/pypyodbc/wiki/Enable_SQLAlchemy_on_IronPython

[3] https://code.google.com/p/pypyodbc/wiki/Enable_SQLAlchemy_on_PyPy

-- 

Fábio C. Barrionuevo da Luz
Acadêmico de Sistemas de Informação na Faculdade Católica do Tocantins - FACTO
Palmas - Tocantins - Brasil - América do Sul

http://pythonclub.com.br/

Blog colaborativo sobre Python e tecnologias Relacionadas, mantido totalmente no https://github.com/pythonclub/pythonclub.github.io .

Todos são livres para publicar. É só fazer fork, escrever sua postagem e mandar o pull-request. Leia mais sobre como publicar em README.md e contributing.md.

Regra básica de postagem:

"Você" acha interessante? É útil para "você"? Pode ser utilizado com Python ou é útil para quem usa Python? Está esperando o que? Publica logo, que estou louco para ler...

[Jonathan Vanasco]

There is an outdated, unsupported dialect for MS Access that has been deprecated to the "attic"

http://docs.sqlalchemy.org/en/latest/dialects/index.html

"""Dialects in the “attic” are those that were contributed for SQLAlchemy long ago but have received little attention or demand since then, and are now moved out to their own repositories in at best a semi-working state. Community members interested in these dialects should feel free to pick up on their current codebase and fork off into working libraries."""

The source is here:

    https://bitbucket.org/zzzeek/sqlalchemy-access 

[Fabio C. Barrionuevo da Luz]

Thanks Jonathan. I will test the indicated library.

--
You received this message because you are subscribed to a topic in the Google Groups "sqlalchemy" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/sqlalchemy/RA3o2ulfDzI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to sqlalchemy+...@googlegroups.com.
To post to this group, send email to sqlal...@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.