Database

Access

import clr
clr.AddReference('System.Data')
from System.Data import *
from System.Data.OleDb import *

connectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=C:/temp/test.mdb"
connection = OleDbConnection(connectionString);
connection.Open()

sql = "select version from parameters"
command = OleDbCommand(sql, connection)
reader = command.ExecuteReader()

while reader.Read():
    print reader[0], reader[1]

reader.Close()
connection.Close()

SQL Server

Accessing SQL Server

import clr
clr.AddReference('System.Data')
from System.Data import *

TheConnection = SqlClient.SqlConnection("server=yourserver;database=News;uid=sa;password=password")
TheConnection.Open()

sql = "Select Headline from News"
MyAction = SqlClient.SqlCommand(sql, TheConnection)
reader = MyAction.ExecuteReader()

while reader.Read():
    print reader[0]

reader.Close()
TheConnection.Close()