#306 error: Unable to find vcvarsall.bat

Andy Dustman
MySQLdb (285)
David Jackson

python version 2.7
OS: win XP SP3, 32 bit
mySQL is 5.1

easy_install and setuptools are already installed,

anther unrelated / resolvable issue was
until i changed it , i was getting registry error b/c the site.cfg file was looking for
"registry_key = SOFTWARE\MySQL AB\MySQL Server 5.0" -- not 5.1 !!!


  • David Jackson
    David Jackson

    error during install

  • David Jackson
    David Jackson

    i installed visual studio, rebooted, and added these locations to my path (file is in the bin):
    c:\Program Files\Microsoft Visual Studio 10.0\VC
    c:\Program Files\Microsoft Visual Studio 10.0\VC\bin

    i still get the same error.
    how can i change / know where it is looking for the file?

  • David Jackson
    David Jackson

    since the file is not able to be found, i ran the install from the folder where the missing file was located. the error has changed a bit -

    i did this
    cd c:\Program Files\Microsoft Visual Studio 10.0\VC
    python c:\temp\MySQL-python-1.2.3\MySQL-python-1.2.3\setup.py install

    the error is now:
    Traceback (most recent call last):
    File "c:\temp\MySQL-python-1.2.3\MySQL-python-1.2.3\setup.py", line 15, in <module>
    metadata, options = get_config()
    File "c:\temp\MySQL-python-1.2.3\MySQL-python-1.2.3\setup_windows.py", line 5, in get_config
    metadata, options = get_metadata_and_options()
    File "c:\temp\MySQL-python-1.2.3\MySQL-python-1.2.3\setup_common.py", line 7, in get_metadata_and_options
    metadata = dict(config.items('metadata'))
    File "c:\Python\27\lib\ConfigParser.py", line 600, in items
    raise NoSectionError(section)
    ConfigParser.NoSectionError: No section: 'metadata'

    however, if i run
    execfile('setup_common.py') the function get_metadata_and_options() works fine.

    per the README for windows
    i set this envio variable to this:
    set mysqlroot="c:\Program Files\MySQL\MySQL Server 5.1"

    i have no "mysql_config" on this machine. should this be commented in site.cfg still?

    THANK YOU!!!