Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: Access 2010 32bit vs Stata 64bit
From
Richard Fox <[email protected]>
To
"[email protected]" <[email protected]>
Subject
st: Access 2010 32bit vs Stata 64bit
Date
Thu, 20 Sep 2012 11:19:17 +0100
Dear Statalist,
I'm having an issue with an odbc link to access database. I know that the link is working fine as SAS is able to import the tables.
I get the following error when trying to import tables or just running an 'odbc list'. The odbc link is listed when in connections but will error if clicking on particular database connection.
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 believe this is a 32bit Access vs 64bit Stata issue. Any advice would be appreciated.
Apologies if this issue is documented. I have searched through my 14000 Statalist emails and could not find any relevant info.
I'll take this opportunity to recommend, and to thank StataCorp et al for, the UK Stata Users Group meeting - a very valuable learning experience in terms of both Statistics and Stata programming.
Best Regards
Richard Fox
Biostatistician - CRCTU
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/