Yes and no. You can generate sql without connection but you still need the driver and looks like we2py cannot find the cx_Oracle driver. Could it be you have two versions of python (one with the driver, and one running web2py)? Anyway, open a ticket about this. we can change it so that you can make SQL even without the driver.
On Saturday, 13 October 2012 04:58:55 UTC-5, Alec Taylor wrote: > > Getting this error: > raise RuntimeError, "no driver available %s", self.drivers TypeError: > raise: arg 3 must be a traceback or None > > Even though I've installed the driver > (instantclient-basic-windows.x64-11.2.0.3.0.zip from > http://www.oracle.com/technetwork/topics/winx64soft-089540.html; + set > ORACLE_HOME env_var to dir where it extracted + added it to PATH) and > python module (cx_Oracle-5.1.2-11g.win-amd64-py2.7.msi from > http://sourceforge.net/projects/cx-oracle/files/5.1.2/). > > Basically I just want to use web2py's DAL, so is there a way I can "fake" > everything? > > Just want to get the SQL Output to plug directly into my DB. > > Thanks for all suggestions, > > Alec Taylor > --
