Oracle & OleDb

An example posted to the IronPython Mailing List, of accessing an Oracle database server using OleDb. The installed version of Oracle was: Oracle Database 10g Express Edition (Universal).

import clr import System clr.AddReference("System.Data")

from System.Data import DataSet from System.Data.OleDb import OleDbConnection, OleDbDataAdapter, OleDbCommand

conStr = "Provider=MSDAORA.1;User ID=name;Password=pwd;Persist Security Info=False"

con = OleDbConnection(conStr)

query = "SELECT * FROM TEST"

adapter = OleDbDataAdapter(query, con) ds = DataSet con.Open

adapter.Fill(ds, "t1") for i in range(ds.Tables["t1"].Rows.Count -1): print ds.Tables["t1"].Rows[i][0] print ds.Tables["t1"].Rows[i][1] print ds.Tables["t1"].Rows[i][2]

con.Close

Back to Contents.