Thanks i am able to connect python to oracle database
but iam talking about connecting using the web2py connection string db = DAL('oracle://schema_name/schema_password@tns_name', pool_size=100) to connect to oracle database thanks On 12/2/11, Lazarof <lazaro...@gmail.com> wrote: > Hi! > Have you tried this? > > export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/ > server/ > export LD_LIBRARY_PATH=$ORACLE_HOME/lib > export PATH=$ORACLE_HOME/bin:$PATH > > sudo apt-get install python-dev python-setuptools > sudo -E easy_install cx_Oracle > > Test: > > $ python >>>> import cx_Oracle >>>> cnxn = cx_Oracle.connect('system/systempasswd@xe') >>>> crsr = cnxn.cursor() >>>> crsr.execute('SELECT * FROM dual') > > > > On Dec 2, 10:26 pm, tOlorun <omnioto...@gmail.com> wrote: >> Thanks for the other time ... >> >> buh iam back again ... >> >> i dont seem to get a hang of connection strings (lols) >> >> please kindly help me with the error below ... >> >> Traceback (most recent call last): >> File "gluon/restricted.py", line 194, in restricted >> File "E:/tOlorun/web2py/web2py/applications/est8ment/models/db.py", >> line 13, in <module> >> File "gluon/dal.py", line 4156, in __init__ >> RuntimeError: Failure to connect, tried 5 times: >> 'NoneType' object has no attribute 'connect' >> >> thanks in advance > -- Oluwaseun Omotosho *Oluwanife@me* To be filled with the life of Christ Jesus and released into our destinies,taking the world for Him. Credit Risk, Card & Ins. Services | Research & Development | Flex Branch & Retail | FASYL Technology Group M: +2348103891218 | M: +2348185780959 | M: +23233487811 | E-mail: omnioto...@gmail.com I omnioto...@live.com <omnioto...@gmail.com> | omnioto...@yahoo.co.uk <omnioto...@gmail.com> I URL ; fasylgroup.com I A Member of *fasyl *Technology Group with presence in Mauritius | UK | India | Nigeria | Ghana | Sierra Leone | South Africa | Zimbabwe | Kenya | Cote d’Ivoire *fasyl *is a BMSL Group Company ….powering business drives This email and all content are subject to the following Disclaimer