oracle - cx_Oracle module installation error message -


i using python 2.7 (32bit) , os 64 bit windows 7.

i trying install cx_oracle module. have run msi "cx_oracle-5.1.2-10g.win32-py2.7.msi", , ran "easy_install cx_oracle" on cmd line , got message:

error: unable find vcvarsall.bat

i found on site best solution install microsoft visual studio 2008, did link found on site.

now when run "easy_install cx_oracle" on cmd line following message, don't know means:

c:\python27>easy_install cx_oracle searching cx-oracle reading ....org/simple/cx_oracle/ reading ....net/crew/atuining reading ...sourceforge.net best match: cx-oracle 5.1.2 downloading http://prdownloads.sourceforge.net/cx-oracle/cx_oracle-5.1.2.tar.gz? download processing cx_oracle-5.1.2.tar.gz writing c:\users\cnielsen\appdata\local\temp\easy_install-44rupd\cx_oracle-5.1.2 \setup.cfg running cx_oracle-5.1.2\setup.py -q bdist_egg --dist-dir c:\users\cnielsen\appda ta\local\temp\easy_install-44rupd\cx_oracle-5.1.2\egg-dist-tmp-eyihnb traceback (most recent call last): file "c:\python27\scripts\easy_install-script.py", line 9, in load_entry_point('setuptools==0.8', 'console_scripts', 'easy_install')() file "build\bdist.win-amd64\egg\setuptools\command\easy_install.py", line 1992 , in main file "build\bdist.win-amd64\egg\setuptools\command\easy_install.py", line 1979 , in with_ei_usage file "build\bdist.win-amd64\egg\setuptools\command\easy_install.py", line 1996 , in file "c:\python27\lib\distutils\core.py", line 152, in setup dist.run_commands() file "c:\python27\lib\distutils\dist.py", line 953, in run_commands self.run_command(cmd) file "c:\python27\lib\distutils\dist.py", line 972, in run_command cmd_obj.run() file "build\bdist.win-amd64\egg\setuptools\command\easy_install.py", line 380, in run file "build\bdist.win-amd64\egg\setuptools\command\easy_install.py", line 623, in easy_install file "build\bdist.win-amd64\egg\setuptools\command\easy_install.py", line 653, in install_item file "build\bdist.win-amd64\egg\setuptools\command\easy_install.py", line 849, in install_eggs file "build\bdist.win-amd64\egg\setuptools\command\easy_install.py", line 1130 , in build_and_install file "build\bdist.win-amd64\egg\setuptools\command\easy_install.py", line 1115 , in run_setup file "build\bdist.win-amd64\egg\setuptools\sandbox.py", line 69, in run_setup file "build\bdist.win-amd64\egg\setuptools\sandbox.py", line 120, in run file "build\bdist.win-amd64\egg\setuptools\sandbox.py", line 71, in file "setup.py", line 350, in file "c:\python27\lib\distutils\core.py", line 152, in setup dist.run_commands() file "c:\python27\lib\distutils\dist.py", line 953, in run_commands self.run_command(cmd) file "c:\python27\lib\distutils\dist.py", line 972, in run_command cmd_obj.run() file "build\bdist.win-amd64\egg\setuptools\command\bdist_egg.py", line 185, in run file "build\bdist.win-amd64\egg\setuptools\command\bdist_egg.py", line 171, in call_command file "c:\python27\lib\distutils\cmd.py", line 326, in run_command self.distribution.run_command(command) file "c:\python27\lib\distutils\dist.py", line 972, in run_command cmd_obj.run() file "build\bdist.win-amd64\egg\setuptools\command\install_lib.py", line 20, n run file "c:\python27\lib\distutils\command\install_lib.py", line 111, in build self.run_command('build_ext') file "c:\python27\lib\distutils\cmd.py", line 326, in run_command self.distribution.run_command(command) file "c:\python27\lib\distutils\dist.py", line 972, in run_command cmd_obj.run() file "build\bdist.win-amd64\egg\setuptools\command\build_ext.py", line 52, in run file "c:\python27\lib\distutils\command\build_ext.py", line 339, in run self.build_extensions() file "c:\python27\lib\distutils\command\build_ext.py", line 448, in build_exte nsions self.build_extension(ext) file "build\bdist.win-amd64\egg\setuptools\command\build_ext.py", line 186, in build_extension file "c:\python27\lib\distutils\command\build_ext.py", line 498, in build_exte nsion depends=ext.depends) file "c:\python27\lib\distutils\msvc9compiler.py", line 473, in compile self.initialize() file "c:\python27\lib\distutils\msvc9compiler.py", line 383, in initialize vc_env = query_vcvarsall(version, plat_spec) file "c:\python27\lib\distutils\msvc9compiler.py", line 299, in query_vcvarsal l raise valueerror(str(list(result.keys()))) valueerror: [u'path']

to reiterate leandro has said, not need easy_install cx_oracle if have ran .msi installer , need install oracle instantclient.

as have found out, installing oracle instantclient means need unzip folder in system (e.g.: c:\oraclient).

some things keep in mind:

make sure using same version (or compatible versions) of cx_oracle, instantclient, , database server itself. instance instantclient v12 not support database servers below version 10). also, make sure using 32 bit or 64 bit versions (including cx_oracle, instantclient, , python itself).

also, need set environment variables oracle_home , path directory unzipped oracle instantclient (e.g.: c:\oraclient) in order avoid importerror mentioned (dll load failed: %1 not valid win32 application). importerror means not find needed libraries.


Comments

Popular posts from this blog

assembly - 8086 TASM: Illegal Indexing Mode -

Java, LWJGL, OpenGL 1.1, decoding BufferedImage to Bytebuffer and binding to OpenGL across classes -

javascript - addthis share facebook and google+ url -