Thanks Massimo!!
Sure enough that was the problem. Once I removed the windows binary and
ran web2py from the source version it recognized the cx_Oracle driver.
Jay
On 03/28/2010 01:10 PM, mdipierro wrote:
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.
