Use 32-bit when 64-bit is installed for Stata 14

[Karen Geurts]

How can I use 32-bit Stata 14 when 64-bit is installed? I only find StataMP-64 in my program files.

The reason is that odbc query and odbc load for importing data from Access do not seem to work with 64-bit.

When running
odbc query "mydata"
I receive following error message:
The ODBC driver reported the following diagnostics
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
SQLSTATE=IM014

I found in previous posts that the solution is to use 32-bit Stata.
see f.ex. http://www.stata.com/statalist/archi.../msg00820.html

Thanks for your help,
Karen

[Hua Peng (StataCorp)]

Simply run the Stata installer again and choose "Modify", then you can choose 32-bit MP to add to your installation. It is very important to run

update all

right after. Since it is very likely the added 32bit StataMP executable is out of sync with your current ado files and Mata libraries.

[wbuchanan]

It looks like there might be a 64-bit ODBC driver available as part of their 2010 distribution: http://www.microsoft.com/en-us/downl....aspx?id=13255.

[Karen Geurts]

Thanks, Hua, I could add the 32-bit flavor and am now able to import from Access.
Karen

[Gloria Salmoral]

I have just updated to STATA 32 bit and updated packages too, but I'm still getting the error "The specified DSN contains an architecture mismatch between the Driver and Application" when I try to import an Access file. Might you know why I'm still getting this error? Thanks.

[Gloria Salmoral]

No worries. The issue was that I actually had to run the 32 bit icon programme...