I did try to import the cx_Oracle module but web2py throws an error
then i realized that web2py is not seeing the oracle driver installed already so now ... How do i make web2py see and use the oracle driver which is already installed Thanks in advance On 12/2/11, Lazarof <[email protected]> wrote: > If you are working with Oracle google for this - Oracle Apex. > > On Dec 2, 11:56 pm, tOlorun <[email protected]> wrote: >> 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 <[email protected]> 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 <[email protected]> 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: [email protected] I [email protected] >> <[email protected]> >> | [email protected] <[email protected]> >> >> 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 > -- 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: [email protected] I [email protected] <[email protected]> | [email protected] <[email protected]> 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
