OK,
If ironPython runs inside .NET Framework, I assumed that the previous mentionned driver dotConnect for VB.Net would be useful. And actually, by transcoding the VB connexion example to python syntax, it works !
I am now able to connect to oracle database inside Rhino without having any oracle client installed on my computer. Unfortunately, this driver is licensed, 150$ a year … fair enough
For those who might be interrested :
import clr clr.AddReference("Devart.Data.Oracle") import Devart.Data.Oracle as dv
connectionBase = dv.OracleConnection() server = "..." port = "..." sid = "..." user = "..." password = "..." connectionBase.ConnectionString = "direct=true;data source={0};port={1};sid={2};user={3};password={4}".format(server, port, sid, user, password) try: dv.OracleConnection.Open(connectionBase) print "Database connected" except dv.OracleException,e : print "Fail to connect to database\n", e SQLCommandeText = "SELECT field1, field2, field3 FROM table WHERE field1='value'" try: commande = dv.OracleCommand(SQLCommandeText, connectionBase) except Exception, e: print e try: dataReader = dv.OracleCommand.ExecuteReader(commande) except Exception, e: print e try: dataList= [] while dataReader.Read(): dataDict= {} dataDict["field1"] = dataReader["field1"] dataDict["field2"] = dataReader["field2"] dataDict["field3"] = dataReader["field3"] dataList.append(dataDict) except Exception, e: print e print dataList