PythonAdoDbApi

UserPreferences

1 개요

여러 가지 모듈 찾아봤는데, 그나마 제일 깔끔하게 설치된 모듈. 유닛 테스트 실패하던데... -_-

2 Connection String

• Access
  

  data_source = "C:\Program Files\Microsoft Office\Office\Samples\northwind.mdb;"
  conn_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + data_source

• SqlServer + Non-trusted Connection
  

  computer_name="(local)"
  database_name="Northwind"
  conn_str = "Provider=SQLOLEDB.1; User ID=sa; Initial Catalog=%s;Data Source=%s" %(database_name, computer_name)

• SqlServer + Trusted-Connection
  

  computer_name = "(local)"
  database_name = "AdventureWorks"
  conn_str = "Provider=SQLOLEDB.1;Initial Catalog=%s;Data Source=%s;Trusted_Connection=Yes" %(database_name, computer_name)

  
  
  

3 샘플

SqlServer + Trusted connection


import win32com.client
import adodbapi

computer_name = "(local)"
database_name = "AdventureWorks"
conn_str = "Provider=SQLOLEDB.1;Initial Catalog=%s;Data Source=%s;Trusted_Connection=Yes" %(database_name, computer_name)

conn = adodbapi.connect(conn_str)
cursor = conn.cursor()

cursor.execute("SELECT AddressID, City FROM Person.Address")
while 1:
    result = cursor.fetchone()
    if result == None:
        break

    print(result[0])

conn.close()

4 링크

• http://adodbapi.sourceforge.net/
  
오피셜 사이트

• see also Python, SqlServer
  

• CategoryLanguage, CategoryDatabase