Re: [web2py] Re: Access remote oracle database

2011-11-28 Thread Humberto Ferreira da Luz Junior
I tried also with python 2.5, but without success. Importing cx_oracle directly in a python script I got this error: import cx_Oracle Traceback (most recent calls last): File stdin, line 1, in module ImportError: DLL load failed with error code 193. I tried installing cx_oracle in my Ubuntu

Re: [web2py] Re: Access remote oracle database

2011-11-28 Thread Humberto Ferreira da Luz Junior
I also tried with the x86 python, but I got the same result. Humberto Ferreira da Luz Junior Mestrado - Ciência da Computação / UEL Analista de Informática - ATI / UEL 2011/11/28 Humberto Ferreira da Luz Junior humbfd...@gmail.com I tried also with python 2.5, but without success.

[web2py] Re: Access remote oracle database

2011-11-28 Thread Massimo Di Pierro
This is a cx_Oracle issue. I suggest you contact the author. He may have a mailing list. On Nov 28, 4:17 am, Humberto Ferreira da Luz Junior humbfd...@gmail.com wrote: I tried also with python 2.5, but without success. Importing cx_oracle directly in a python script I got this error:import

Re: [web2py] Re: Access remote oracle database

2011-11-28 Thread Humberto Ferreira da Luz Junior
I solved the problem in cx_oracle mailing list. That was happening because the Oracle Client wasn't installed (I was using only the SQL Developer to access the remote database). I installed the oracle client (instantclient-basic-windows.x64-11.2.0.2.0), set the ORACLE_HOME variable and added it to

Re: [web2py] Re: Access remote oracle database

2011-11-25 Thread Humberto Ferreira da Luz Junior
I can access the remote database through SQL Developer and also from my local java applications. My db.py: db = DAL(oracle://user/passw...@server.ip:1521/dese) Then when I try to access the database administration I get the following error: type 'exceptions.RuntimeError'(Failure to connect,

[web2py] Re: Access remote oracle database

2011-11-25 Thread Massimo Di Pierro
Looks like web2py cannot find cx_Oracle. At startup, do you see Oracle listed as one of the available database engines? On Nov 25, 4:48 am, Humberto Ferreira da Luz Junior humbfd...@gmail.com wrote: I can access the remote database through SQL Developer and also from my local java

Re: [web2py] Re: Access remote oracle database

2011-11-25 Thread Humberto Ferreira da Luz Junior
No, oracle is not listed at web2py startup. I installed python 2.7 and cx_oracle 5.1.1-10g.win-amd64-py2.7.msi. Should I use an older version? Humberto Ferreira da Luz Junior Mestrado - Ciência da Computação / UEL Analista de Informática - ATI / UEL 2011/11/25 Massimo Di Pierro

Re: [web2py] Re: Access remote oracle database

2011-11-25 Thread Humberto Ferreira da Luz Junior
I tried python 2.6.6 with cx_oracle 5.1 and I got the same results. The oracle driver is not listed in the web2py console at startup (running from the source). Humberto Ferreira da Luz Junior Mestrado - Ciência da Computação / UEL Analista de Informática - ATI / UEL

[web2py] Re: Access remote oracle database

2011-11-25 Thread Massimo Di Pierro
start python (not web2py) and try import cx_Oracle does it work? If no the problem is with the installation of cx_Oracle. If it works, than make sure you use the same python interpreter with web2py. On Nov 25, 1:11 pm, Humberto Ferreira da Luz Junior humbfd...@gmail.com wrote: I tried python

[web2py] Re: Access remote oracle database

2011-11-24 Thread Massimo Di Pierro
I think oracle://myusername:mypassword@server_ip_address:1521/database_name On Nov 24, 8:43 am, Humberto humbfd...@gmail.com wrote: Hi, I just started using web2py and I'm don't know how to connect to my remote oracle database. According with the chapter 6 of the official book the url should

[web2py] Re: Access remote oracle database

2011-11-24 Thread Humberto
web2py already comes with native oracle support? I installed pyodbc and cx_oracle, but I still can't connect to my remote oracle database. I tested a connection with postgres (I needed to install psycopg2) and it's working fine. Ps. My OS is Windows 7 x64. Ps2. I tried running the web2py binary

[web2py] Re: Access remote oracle database

2011-11-24 Thread Massimo Di Pierro
Web2py supports oracle. Requires cxoracle and rinning from source. What problem do you experience? On Nov 24, 12:42 pm, Humberto humbfd...@gmail.com wrote: web2py already comes with native oracle support? I installed pyodbc and cx_oracle, but I still can't connect to my remote oracle

[web2py] Re: Access remote oracle database

2011-11-24 Thread tomt
Do you have the oracle client installed on your web2py machine? If you do, you should be able to test the connection to oracle with 'sqlplus database/password'. oracle-instantclient is available for free from www.oracle.com/technetwork/index.html. I'm using this on my linux machine to access a