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]
RE: st: Access 2010 32bit vs Stata 64bit
From
"Deppen, Steve" <[email protected]>
To
"'[email protected]'" <[email protected]>
Subject
RE: st: Access 2010 32bit vs Stata 64bit
Date
Fri, 21 Sep 2012 14:49:30 +0000
This is the path to 64 Bit ODBC connections on a 64 bit machine.
C:\Windows\SysWOW64\odbcad32.exe
You can access the 32 bit ODBC Connections from this path on a 32 Bit or 64 Bit machine.
Control Panel\All Control Panel Items\Administrative Tools\Data Sources (ODBC).link
If that doesn't work you may need to remove your Office 2010 which is default 32bit and install Access as a 64bit program.
Be careful however, as a 64bit install will not allow you to use 32 bit plug in's or specialized interactive programs like cite while
you write with endnote, for example.
Stephen Deppen MA, MS
Healthsystems Database Analyst
Department of Thoracic Surgery
Institute for Medicine and Public Health
609 Oxford House
1313 21st Ave South
Nashville, TN 37232
615-343-6284 (phone)
615-936-7003 (fax)
Date: Thu, 20 Sep 2012 11:19:17 +0100
From: Richard Fox <[email protected]>
Subject: st: Access 2010 32bit vs Stata 64bit
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/
*
* 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/