db access

[king kikapu]

Hi to all,

is there a way to use an RDBMS (in my case, SQL Server) from Python by
using some built-in module of the language (v. 2.5) and through ODBC ??
I saw some samples that use statements like "import dbi" or "import
odbc" but neither modules (dbi, odbc) are present on my system...

Any hint(s) ??

Thanks in advance

 

[Martin P. Hellwig]

Hi to all,

is there a way to use an RDBMS (in my case, SQL Server) from Python by
using some built-in module of the language (v. 2.5) and through ODBC ??
I saw some samples that use statements like "import dbi" or "import
odbc" but neither modules (dbi, odbc) are present on my system...

Any hint(s) ??

Thanks in advance

Hey there,

Take a look at this:
http://www.python.org/doc/topics/database/

Cheers,

 

[king kikapu]

Hey Martin,

thanks for the fast reply!

I have already seen that link and i just downloaded the pyodbc module
but isn't Python already containing a "built-in" odbc module so to
allow for db communication ??

 

[Martin P. Hellwig]

Hey Martin,

thanks for the fast reply!

I have already seen that link and i just downloaded the pyodbc module
but isn't Python already containing a "built-in" odbc module so to
allow for db communication ??

<cut>
Not that I'm aware of, but it is possible to do odbc with the win32
extensions which are commonly installed on windows machines, perhaps
you've seen something like that?

 

[Laszlo Nagy]

king kikapu írta:

Hey Martin,

thanks for the fast reply!

I have already seen that link and i just downloaded the pyodbc module
but isn't Python already containing a "built-in" odbc module so to
allow for db communication ??

There is no built-in ODBC module. We all know that Python comes with
batteries included. So if you only want to play with SQL then you
can use the SQLite package. That is built in Python 2.5. But if you wish
to connect to MS SQL, you need to install a third party package. Python
does not come with submarine battery packs included, only simple
batteries. The good news is that it costs nothing to install additional
extensions.

By the way, if you plan to use MS SQL from Python, I would recommend ADO
instead. ODBC is very old technology. ADO is much better supported. ADO
can be accessed from Activestate Python (which is a special Python
version from the win32 platform). The other alternative is to install
the win32 extensions for Python. (And probably there are other
alternatives as well.)

I recommend this:

http://www.mayukhbose.com/python/ado/index.php

Best,

Laszlo

 

[Chris Mellon]

<cut>
Not that I'm aware of, but it is possible to do odbc with the win32
extensions which are commonly installed on windows machines, perhaps
you've seen something like that?

Yes, but you don't want to. Use pyodbc (or adodbapi, if you're windows
only) and save yourself the trouble.

 

[johnf]

Hi to all,

is there a way to use an RDBMS (in my case, SQL Server) from Python by
using some built-in module of the language (v. 2.5) and through ODBC ??
I saw some samples that use statements like "import dbi" or "import
odbc" but neither modules (dbi, odbc) are present on my system...

Any hint(s) ??

Thanks in advance

Although others have suggested using ODBC or ADO I have a different
solution. If you wanted a multi-platform I would use FreeTDS with
psmssql.py. psmssql.py does support the DB API 2.0 although it does not
support any of the extendsions. Works with Linux, Mac and Windows.

Johnf

 

[king kikapu]

Hi Johnf,

are you referring to this ?
http://www.freetds.org/

And how i can get psmssql.py so i can get a shot on it, is it included
in FreeTDS ??

 

[vasudevram]

Its not really related to your question, but if you also want to
publish your database data to PDF, here's one way:

http://mail.python.org/pipermail/python-list/2006-July/392099.html

Vasudev
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Vasudev Ram
Dancing Bison Enterprises
Software training and consulting
http://www.dancingbison.com
http://www.dancingbison.com/products.html
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~