This is a cx_Oracle installation issue and you should email their list at 
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users .


On Jul 6, 2011, at 4:22 AM, Upul Iroshan Abayagunawardhana wrote:

> 
> I found in the cx_oracle.py dialect file line 537 is as follows
> 
> def dbapi(cls):
>         import cx_Oracle
>         return cx_Oracle
>         
> But when i included those two lines in python script and run using eclipse it 
> runs without any error. When printed it gave something like following.
> <module 'cx_Oracle' from 'C:\Python26\lib\site-packages\cx_Oracle.pyd'>
> 
> Since I am new to python programming, I can't understand what is the problem 
> here. Is it some configuration related issue. I observed that there's no 
> oracle related DLLs in C:\Python26\DLLs directory.
> 
> Thanks.
> 
> On Tue, Jul 5, 2011 at 8:31 PM, Upul Iroshan Abayagunawardhana 
> <upuliros...@gmail.com> wrote:
> Hi all,
> 
> I am trying to write some plugin for Tiddlyspace[1], Which is using
> sqlalchemy for Data Access. Currently it's support MySQL. But now I am
> trying to use it with Oracle. So I've installed oracle driver for
> windows [2].
> 
> I've tried out some samples without sqlalchemy and with sqlalchemy.
> Both samples worked fine and gave expected output. But when I am
> trying to integrate with tiddlywiki i am getting following error.
> 
> 2011-07-05 13:41:15,078 WARNING  Traceback (most recent call last):
>  File "C:\Python26\lib\site-packages
> \tiddlywebplugins.prettyerror-0.9.5-py2.6.egg\tiddlywebplugins
> \prettyerror\exceptor.py", line 56, in __call__
>    return self.application(environ, start_response)
>  File "C:\Python26\lib\site-packages\tiddlyweb-1.2.36-py2.6.egg
> \tiddlyweb\web\wsgi.py", line 258, in __call__
>    output = self.application(environ, start_response)
>  File "C:\Python26\lib\site-packages\tiddlyweb-1.2.36-py2.6.egg
> \tiddlyweb\web\wsgi.py", line 47, in __call__
>    output = self.application(environ, start_response)
>  File "C:\Python26\lib\site-packages\tiddlyweb-1.2.36-py2.6.egg
> \tiddlyweb\web\serve.py", line 113, in __call__
>    return self.application(environ, start_response)
>  File "C:\Python26\lib\site-packages\tiddlyweb-1.2.36-py2.6.egg
> \tiddlyweb\web\serve.py", line 98, in __call__
>    return self.application(environ, start_response)
>  File "C:\Python26\lib\site-packages\tiddlyweb-1.2.36-py2.6.egg
> \tiddlyweb\web\query.py", line 27, in __call__
>    return self.application(environ, start_response)
>  File "C:\Python26\lib\site-packages
> \tiddlywebplugins.pathinfohack-0.9.1-py2.6.egg\tiddlywebplugins
> \pathinfohack.py", line 40, in __call__
>    return self.application(environ, start_response)
>  File "C:\Python26\lib\site-packages\tiddlyweb-1.2.36-py2.6.egg
> \tiddlyweb\web\wsgi.py", line 216, in __call__
>    environ)
>  File "C:\Python26\lib\site-packages\tiddlyweb-1.2.36-py2.6.egg
> \tiddlyweb\store.py", line 106, in __init__
>    self._import()
>  File "C:\Python26\lib\site-packages\tiddlyweb-1.2.36-py2.6.egg
> \tiddlyweb\store.py", line 121, in _import
>    self.storage = imported_module.Store(self.config, self.environ)
>  File "C:\Python26\lib\site-packages
> \tiddlywebplugins.sqlalchemy2-2.0.5-py2.6.egg\tiddlywebplugins
> \sqlalchemy2\__init__.py", line 344, in __init__
>    self._init_store()
>  File "C:\Python26\lib\site-packages\tiddlywebplugins.oracle10g-0.0.1-
> py2.6.egg\tiddlywebplugins\oracle.py", line 89, in _init_store
>    ENGINE = create_engine(self._db_config())
>  File "C:\Python26\lib\site-packages\sqlalchemy-0.7.1-py2.6.egg
> \sqlalchemy\engine\__init__.py", line 263, in create_engine
>    return strategy.create(*args, **kwargs)
>  File "C:\Python26\lib\site-packages\sqlalchemy-0.7.1-py2.6.egg
> \sqlalchemy\engine\strategies.py", line 64, in create
>    dbapi = dialect_cls.dbapi(**dbapi_args)
>  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.
> 
> Please help me to resolve above issue.
> 
> Thanks,
> Upul Abayagunawardhana.
> 
> [1] : http://tiddlyspace.com/
> [2] : 
> http://prdownloads.sourceforge.net/cx-oracle/cx_Oracle-5.1-10g.win32-py2.6.msi?download
> 
> 
> 
> -- 
> Upul Abayagunawardhana
> Mobile:  +94 713 280 622
> 
> 
> 
> 
> 
> 
>  
> 
> 
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "sqlalchemy" group.
> To post to this group, send email to sqlalchemy@googlegroups.com.
> To unsubscribe from this group, send email to 
> sqlalchemy+unsubscr...@googlegroups.com.
> For more options, visit this group at 
> http://groups.google.com/group/sqlalchemy?hl=en.

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.

Reply via email to