Python database access

[arvind]

Hi all,
I am going to work on Python 2.4.3 and MSSQL database server on
Windows platform.
But I don't know how to make the connectivity or rather which module to
import.
I searched for the modules in the Python library, but I couldn't find
which module to go for.
Please help me out!

[Serge Orlov]

On 25 Jun 2006 21:19:18 -0700, arvind <ar**********@gmail.com> wrote:

Hi all,
I am going to work on Python 2.4.3 and MSSQL database server on
Windows platform.
But I don't know how to make the connectivity or rather which module to
import.
I searched for the modules in the Python library, but I couldn't find
which module to go for.

The module you're looking for is the first result if you search
"python mysql" on google or if you search "mysql" on python package
index <http://www.python.org/pypi>

[Dave Cook]

On 2006-06-26, Serge Orlov <se*********@gmail.com> wrote:

On 25 Jun 2006 21:19:18 -0700, arvind <ar**********@gmail.com> wrote:

I am going to work on Python 2.4.3 and MSSQL database server on
Windows platform.

The module you're looking for is the first result if you search
"python mysql" on google or if you search "mysql" on python package
index <http://www.python.org/pypi>

I think he meant Microsoft SQL Server. In which case, google searches on
"python mssql" and "python odbc" should be helpful.

Dave Cook

[defcon8]

arvind wrote:

Hi all,
I am going to work on Python 2.4.3 and MSSQL database server on
Windows platform.
But I don't know how to make the connectivity or rather which module to
import.
I searched for the modules in the Python library, but I couldn't find
which module to go for.
Please help me out!

I think there are a few recipes for mssql in the activestate python
cookbook, or at least for odbc.

[BartlebyScrivener]

> But I don't know how to make the connectivity or rather which module to

import.

Try mxODBC

http://www.egenix.com/files/python/mxODBC.html

[vasudevram]

The odbc module is part of the Python Standard Library. So you can
search for docs on using it in the Python2x.chm help file (or the HTML
version of the same docs) that comes with the Windows Python
disttribution. Its quite easy to use ODBC from Python, at least for
simple tasks like "select * from tablename".

Vasudev Ram
http://www.geocities.com/vasudevram
PDF conversion toolkt:
http://sourceforge.net/projects/xtopdf
BartlebyScrivener wrote:

But I don't know how to make the connectivity or rather which module to
import.

Try mxODBC

http://www.egenix.com/files/python/mxODBC.html

[madpython]

arvind wrote:

Hi all,
I am going to work on Python 2.4.3 and MSSQL database server on
Windows platform.
But I don't know how to make the connectivity or rather which module to
import.
I searched for the modules in the Python library, but I couldn't find
which module to go for.
Please help me out!

i suggest pymssql. It doesnt throw runtime error while executing a
query where prepackaged odbc module does.

[Damjan]

> The odbc module is part of the Python Standard Library.

Since when?
--
damjan

[Steve Holden]

Damjan wrote:

The odbc module is part of the Python Standard Library.

Since when?

Nope, it's a standard part of Mark Hammond's win32all extensions. As
such it probably comes with ActivePython for Windows, which many people
use as their standard distro.

regards
Steve
--
Steve Holden [phone] [phone]
Holden Web LLC/Ltd http://www.holdenweb.com
Love me, love my blog http://holdenweb.blogspot.com
Recent Ramblings http://del.icio.us/steve.holden

[vasudevram]

Yes, Steve is right. Sorry for the mistake. In my case, I don't use
Active Python, I use the vanilla Python for Windows (the .msi installer
from python.org) and then immediately install the win32all package,
link to which is usually on the same page as the MSI. I do this as a
routine, whenever I upgrade my Windows Python version. Mainly use
win32all for the PythonWin IDE (a pretty decent one, particularly the
debugging support) which comes with it, though the win32all package
also has some support for using COM from Python.

So when I did an "import ODBC", since I had not separately installed an
ODBC module, I thought it was part of the Standard Library - whereas
its a part of win32all.

Vasudev
---
Vasudev Ram
Independent software consultant
Personal page: http://www.geocities.com/vasudevram
PDF conversion toolkit: http://sourceforge.net/projects/xtopdf (written
in Python, requires Python v2.2 or higher, ReportLab toolkit
(http://www.reportlab.org) v1.17 or higher).
Blog on software innovation: http://jugad.livejournal.com
---

Steve Holden wrote:

Damjan wrote:

The odbc module is part of the Python Standard Library.

Since when?

Nope, it's a standard part of Mark Hammond's win32all extensions. As
such it probably comes with ActivePython for Windows, which many people
use as their standard distro.

regards
Steve
--
Steve Holden [phone] [phone]
Holden Web LLC/Ltd http://www.holdenweb.com
Love me, love my blog http://holdenweb.blogspot.com
Recent Ramblings http://del.icio.us/steve.holden