Re: Python database access

2006-06-29 Thread 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   +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

2006-06-28 Thread 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   +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

2006-06-27 Thread Damjan
 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

2006-06-26 Thread Dave Cook
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

2006-06-26 Thread 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.

-- 
http://mail.python.org/mailman/listinfo/python-list


Re: Python database access

2006-06-26 Thread 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

-- 
http://mail.python.org/mailman/listinfo/python-list


Re: Python database access

2006-06-26 Thread 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

-- 
http://mail.python.org/mailman/listinfo/python-list


Re: Python database access

2006-06-26 Thread 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.

-- 
http://mail.python.org/mailman/listinfo/python-list


Python database access

2006-06-25 Thread 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!

-- 
http://mail.python.org/mailman/listinfo/python-list


Re: Python database access

2006-06-25 Thread Serge Orlov
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