I have also tried changing the Python interpreter in FME to point to the Python 2.6 interpreter that ArcGIS installs, but FME says that this version of the Python interpreter is not supported. I've also tried appending to sys.path and setting the PYTHONPATH, but nothing works. Looks like I need adodbapi for Python 2.7 installed in the folder for FME, which is FME\\fmepython27.
Any suggestions?
Thanks