Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Access 2010 32bit vs Stata 64bit


From   Richard Fox <r.p.fox@bham.ac.uk>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index