best way to access ms sql server?

dique chezdique at yahoo.com
Thu Dec 5 06:20:28 EST 2002


I use ADO.
cn = win32com.client.Dispatch("ADODB.Connection")
rs = win32com.client.Dispatch("ADODB.Recordset")
cn.Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=TestDB;Data Source=(local)")
rs.Open(sql, cn)
while not rs.EOF:
    # process rs
    rs.MoveNext()
rs.Close()
cn.Close()

"Randall Smith" <netmail at tnr.cc> wrote in message
news:SjzH9.110057$Kj1.4522091 at twister.austin.rr.com...
> what is the best way to access microsoft's sql server with Python?
>
> Randall
>





More information about the Python-list mailing list