Re: Python database access
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 +44 150 684 7255 +1 800 494 3119 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 -- http://mail.python.org/mailman/listinfo/python-list
Re: Python database access
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 +44 150 684 7255 +1 800 494 3119 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 -- http://mail.python.org/mailman/listinfo/python-list
Re: Python database access
The odbc module is part of the Python Standard Library. Since when? -- damjan -- http://mail.python.org/mailman/listinfo/python-list
Re: Python database access
On 2006-06-26, Serge Orlov [EMAIL PROTECTED] wrote: On 25 Jun 2006 21:19:18 -0700, arvind [EMAIL PROTECTED] 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 -- http://mail.python.org/mailman/listinfo/python-list
Re: Python database access
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. -- http://mail.python.org/mailman/listinfo/python-list
Re: Python database access
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 -- http://mail.python.org/mailman/listinfo/python-list
Re: Python database access
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 -- http://mail.python.org/mailman/listinfo/python-list
Re: Python database access
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. -- http://mail.python.org/mailman/listinfo/python-list
Python database access
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! -- http://mail.python.org/mailman/listinfo/python-list
Re: Python database access
On 25 Jun 2006 21:19:18 -0700, arvind [EMAIL PROTECTED] 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 -- http://mail.python.org/mailman/listinfo/python-list