The problem seems to be that web2py is not finding the module. I do
not think this has anything to do with versions.
Are you using the source version of web2py? If not, the windows binary
distribution of web2py comes with its own python interpreter and it
will not see modules you installed in the "other" python.
Massimo
On 27 Mar, 22:50, Jason Lotz <jayl...@gmail.com> wrote:
> The only problem is that python interpreter itself seems to recognize
> the cx_Oracle driver. I am able to make a connection in the Python
> Shell. I only get the error when trying to connect using web2py DAL in
> the Interactive Shell.
>
> Is there any version compatibilities issue?
>
> Windows 2003 Server
> Python v2.5
> cx_Oracle v5.0.3-10g-win32-py2.5
> Oracle v10g
> web2py v1.76.5
>
> Should I try a lower version of cx_Oracle or web2py?
>
> --Jay
>
> On Mar 28, 9:41 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > I suggest you email the creators of cx_Oracle. You should not need to
> > install it under web2py/site-packages. If it is normally installed
> > under Python, web2py should be able t use it.
>
> > On 27 Mar, 13:07, Jason Lotz <jayl...@gmail.com> wrote:
>
> > > I have tried to build and install from source but I get another error.
>
> > > >python setup.py build
> > > running build
> > > running build_ext
> > > building 'cx_Oracle' extension
> > > error: Unable to find vcvarsall.bat
>
> > > You said "...installing it into your python's site-packages.". I have
> > > only installed the cx_Oracle binary but if I look in
> > > 'C:\Python26\Lib\site-packages' it appears to have already been
> > > installed as the cx_Oracle.pyd exists here. Just for a wild shot I
> > > copied this file to the ~\web2py\site-packages but that made no
> > > difference.
>
> > > What am I doing wrong or missing?
>
> > > --
> > > Jay
>
> > > On 03/28/2010 02:17 AM, Thadeus Burgess wrote:
>
> > > > I think that it means to run the source version of cx_oracle not the
> > > > binary version. This would entail downloading the source of cx_Oracle
> > > > and installing it into your python's site-packages.
>
> > > > -Thadeus
>
> > > > On Sat, Mar 27, 2010 at 10:51 AM, Jason Lotz<jayl...@gmail.com> wrote:
>
> > > >> I am trying to connect to an established oracle database. Working in
> > > >> Windows I downloaded and installed cx_Oracle. In the Python Shell I am
> > > >> able to make a connection.
>
> > > >>>>> db = DAL('oracle://user/passw...@tns')
>
> > > >> Traceback (most recent call last):
> > > >> File "<console>", line 1, in<module>
> > > >> File "gluon/sql.py", line 3783, in DAL
> > > >> File "gluon/sql.py", line 966, in __init__
> > > >> File "gluon/sql.py", line 829, in _pool_connection
> > > >> File "gluon/sql.py", line 967, in<lambda>
> > > >> NameError: global name 'cx_Oracle' is not defined
>
> > > >> I read that I need to run web2py from the cx_oracle source. I'm not
> > > >> sure how to 'run from source'. Maybe there is someone that could point
> > > >> me in the right direction.
>
> > > >> Thnx,
> > > >> Jay
>
> > > >> --
> > > >> You received this message because you are subscribed to the Google
> > > >> Groups "web2py-users" group.
> > > >> To post to this group, send email to web...@googlegroups.com.
> > > >> To unsubscribe from this group, send email to
> > > >> web2py+unsubscr...@googlegroups.com.
> > > >> For more options, visit this group
> > > >> athttp://groups.google.com/group/web2py?hl=en.
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
