First check it is installed correctly. start python (not web2py) and try to import cx_Oracle
if that works but it does not work in web2py then web2py is using a different Python version. Make sure you run web2py from source and not the binary, the binary has its own python. On Dec 3, 9:50 am, tOlorun <omnioto...@gmail.com> wrote: > 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 <lazaro...@gmail.com> wrote: > > > > > > > > > > > If you are working with Oracle google for this - Oracle Apex. > > > On Dec 2, 11:56 pm, tOlorun <omnioto...@gmail.com> 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 <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 > > -- > 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