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