>I've having a very odd and frustrating problem.
>
>I have an ODBC connection setup to connect to an Oracle database.
>
>If I go into the ODBC Data Source Administrator - and test the connection - it works.
>
>However, when I go to foxpro and test the connection I made ... I get this:
>
>Connectivity error: [Microsoft] ODBC Driver Manager] Driver's SQLAllocHandle on SQL_Handle_ENV failed.
>
>anyone got a clue? What's really strange is sometimes if I go back to the ODBC Data Source Admin window and play around with it for a few minutes...then for a short period of time all seems to work in VFP.... Driving me NUTS!

You can check your connection parameters at http://www.connectionstrings.com/

If you're working on a 64-bit Win7 box you need to make sure you use the 32-bit ODBC administrator to set up 32-bit connections compatible with VFP. It's usually C:\Windows\SysWOW64\odbcad32.exe.