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]

RE: st: Access 2010 32bit vs Stata 64bit


From   "Deppen, Steve" <steve.deppen@vanderbilt.edu>
To   "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu>
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 <r.p.fox@bham.ac.uk>
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/


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