Re: "Correct" db adapter

king kikapu a écrit :
Thanks for the replies.

I think i do not need something like ORM, but just a db-module that i
can "work" the database with it.

FWIW, SQLAlchemy is not an ORM, but an higher-level API for SQL integration. The ORM part is an optional feature built on top of this API. But I'm not sure SQLAlchemy supports SQL Server anyway !-)

I just want to know if pyodbc is the "correct" solution to do so or if
it is another db-module that is more
usefull for this job.

AFAICT:

* there's an experimental MS SQL Server db-module:
http://www.object-craft.com.au/projects/mssql/

* the Win32 extensions offers support for ADO, but then it's not db-api compliant

* unless you use adodbapi, but I don't know if it's still supported (last release is 3+ years old):
http://adodbapi.sourceforge.net/

HTH
.

Relevant Pages

  • Re: "Correct" db adapter
    ... I think i do not need something like ORM, but just a db-module that i ... FWIW, SQLAlchemy is not an ORM, but an higher-level API for SQL ... But I'm not sure SQLAlchemy supports SQL Server anyway!-) ...
    (comp.lang.python)
  • Re: "Correct" db adapter
    ... king kikapu wrote: ... I think i do not need something like ORM, but just a db-module that i ... can "work" the database with it. ...
    (comp.lang.python)
  • Re: "Correct" db adapter
    ... I think i do not need something like ORM, but just a db-module that i ... can "work" the database with it. ... usefull for this job. ...
    (comp.lang.python)