Thanks a lot for the Reply Ben, I'll looking into this.
On Wed, Jul 6, 2011 at 5:52 PM, Ben Gillies <[email protected]> wrote: > Hi Uprul > > But now I am > > trying to use it with Oracle. So I've installed oracle driver for windows > > [2]. > > Ok, that's not been done before as far as I know, so I'll do my best > to help you out. > > ...<snip>... > > File "C:\Python26\lib\site-packages\sqlalchemy-0.7.1-py2.6.egg > > \sqlalchemy\dialects\oracle\cx_oracle.py", line 537, in dbapi > > import cx_Oracle > > ImportError: DLL load failed: The specified module could not be found. > > This message suggests that Python (for some reason) cannot find the > correct DLL, causing the cx_Oracle module to fail to load. > > As I say, I don't have much direct experience with Oracle, but the > relevant StackOverflow question [1] suggests checking the following: > > * Install a pre-compiled binary package [2] relating to the correct > versions of Oracle and Python > * set ORACLE_HOME if this environment variable doesn't exist (see this > Oracle FAQ [3]) > * python can find oraocci11.dll for Oracle 11g, oraocci10.dll for > Oracle 10g or oraclient9.dll for Oracle 9i by adding the folder > (should be %ORACLE_HOME%/bin) where the DLL is in you PATH environment > variable. > > Yet another post [4] seems to suggest that you may also need the > client version of Oracle installed as well. > > > Hope this helps > > > Ben > > [1] > http://stackoverflow.com/questions/1711408/help-installing-cx-oracle/1711468#1711468 > [2] http://sourceforge.net/projects/cx-oracle/files/ > [3] http://www.orafaq.com/wiki/ORACLE_HOME > [4] > http://stackoverflow.com/questions/5026945/oracle-and-python-cx-oracle-dll-load-failed/5027404#5027404 > > -- > You received this message because you are subscribed to the Google Groups > "TiddlyWiki" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/tiddlywiki?hl=en. > > -- *Upul Abayagunawardhana **Mobile: *+94 713 280 622 <http://www.virtusa.com/> <http://www.virtusa.com/blog/><http://www.twitter.com/uiroshan><http://lk.linkedin.com/in/upuliroshan><http://www.facebook.com/iroshan><http://www.youtube.com/uiroshan> -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/tiddlywiki?hl=en.

