Dardo: Why are you going to all this work? You could simply... import adodbapi which has all of the COM interface things already written.
There is a new version which has the ability to access columns by name, and which uses objects to read data directly from the recordset (rather than copying data into Python tuples.) You can pick it up from http://sourceforge.net/projects/adodbapi/ -- that installer will replace the copy which comes with pywin32. It passes all of the tests (including reading and writing ACCESS tables) -- but someone trying the new features in a new application would be very welcome. Unit tests can miss things. Please try it out and let me (and everyone else) know how it works for you. -- Vernon Cole On Thu, Sep 2, 2010 at 4:36 AM, Dardo Schuster Glez < dardoschus...@hotmail.com> wrote: > Dear Sirs > > I was programming many years with delphi/sql server and now i am looking > python with your ado library to migrate . I am making my first ado program > with python using python 3.1 and pythonwin but i have a problem : recordset > can´t acces fields data i send you a sample and the answer from python > > # First import two useful modules > import win32com.client > from adoconstants import * > # Create the ADO Connection object via COM. > oConn = win32com.client.Dispatch('ADODB.Connection') > # Now set the connection properties via the ConnectionString > # We're connecting to a SQL Server on 192.168.1.100 using OLEDB. > oConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data > Source=C:\personal.mdb;" > # Now open the connection > oConn.Open() > > if oConn.State == adStateOpen: > # Do something here > print ("We've connected to the database.") > # Now create a RecordSet object and open a table > rs = win32com.client.Dispatch('ADODB.Recordset') > rs.Open("select * from agenda",oConn,1,3) # Open a table > called agenda > # Can also use oRS.Open("zipcode", oConn) instead of setting > ActiveConnection > print( repr(rs)) > > while not rs.EOF: > print (rs.fields("nombre")) > # Move to the next record in the RecordSet > rs.MoveNext() > > # Close up the connection and unload the COM object > if oConn.State == adStateOpen: oConn.Close() > oConn = None > > > Answer from python > > We've connected to the database. > <win32com.gen_py.Microsoft ActiveX Data Objects 2.8 Library._Recordset > instance at 0x26371984> > Traceback (most recent call last): > File "C:\Dardo\Lenguaje Python\ado\Ejemplo\base-de-datos.py", line 27, in > <module> > print (rs.fields("nombre")) > File "C:\Python31\lib\site-packages\win32com\client\__init__.py", line > 462, in __getattr__ > raise AttributeError("'%s' object has no attribute '%s'" % (repr(self), > attr)) > AttributeError: '<win32com.gen_py.Microsoft ActiveX Data Objects 2.8 > Library._Recordset instance at 0x26371984>' object has no attribute 'fields' > > Which is the problem ??? > Please answer a soon as posible > Thanks > Dardo R. Schuster > Tenerife - canary islands - Spain > > > > > _______________________________________________ > python-win32 mailing list > python-win32@python.org > http://mail.python.org/mailman/listinfo/python-win32 > >
_______________________________________________ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32
