Hi!
Several solution are given.
Another (example) :
import win32com.client
from win32com.client import Dispatch
connexion = Dispatch('ADODB.Connection')
connexion.ConnectionString = "Provider=SQLOLEDB.1; Data
Source=192.168.10.10; uid=username; pwd=password; database=baseSQLdata"
connexion.Open()
if connexion.State == 1:
print "connected."
recordset = Dispatch('ADODB.RecordSet')
recordset.ActiveConnection = connexion
recordset.Open("tablexample")
while not recordset.EOF:
print recordset.Fields.Item("mail").Value,
recordset.Fields(2).Value
recordset.Close()
recordset = None
connexion.Close()
connexion = None
@-salutations
--
Michel Claveau
_______________________________________________
python-win32 mailing list
python-win32@python.org
http://mail.python.org/mailman/listinfo/python-win32
