大多数据是从网上找的,自己做个总结
----------------------------------------------------------------------
PYTHON:使用 WIN32COM 连接 ODBC
import win32com.client as wc
dispatch=wc.Dispatch
conn=dispatch("ADODB.connection")
rs=dispatch("ADODB.Recordset")
constr='''xxxxxxxxxxxxxxxxxxxx'''
sql='''xxxxxxxxxxxxxxxxxxxxxx'''
conn.Open(constr)
rs.Open(sql,conn)
fields=[rs(i).name for i in range(rs.Fileds.Count)]
fieldsvalues=[[i,rs.Fields.Item(i).Value] for i in fields]
rs.close
conn.close
----------------------------------------------------------------------
autolisp 连接 ODBC
(vl-load-com)
(setq dispatch (lambda (x) (vlax-create-object x)))
(setq conn (dispatch "ADODB.connection"))
(setq rs (dispatch "ADODB.Recordset")