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.
