st: Re: Stata11 64bit MP Windows 7 & odbc

["Joseph Coveney" <jcoveney@bigplanet.com>]

Richard Palmer-Jones wrote:

I cannot get the workaround suggested by Kevin Crow to solve the odbc
problem  with 64 bit stata in windows 7
(http://www.stata.com/statalist/archive/2009-12/msg00810.html - to run
32 bt stata by downloading it from
http://www.stata.com/support/updates/stata11/win/ StatMP.bin, to my
stata 64 bit  directory and changing the extension to .exe). It does
not run even after changing its compatibility.

I am told that the StatMP.exe is not a valid Win32 bit application.

--------------------------------------------------------------------------------

Has anyone looked into the Microsoft Database Engine 2010 Redistributable?  The 
URL is
www.microsoft.com/downloads/en/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B
371EDE16D&displaylang=en

"This download will install a set of components that facilitate the transfer of 
data between existing Microsoft Office files such as Microsoft Office 
Access 2010 (*.mdb and *.accdb) files and Microsoft Office Excel 2010 (*.xls, 
*.xlsx, and  *.xlsb) files to other data sources such as Microsoft SQL Server 
[and Stata?].  . . . ODBC and OLEDB drivers are installed for application 
developers to use in developing their applications with connectivity to Office 
file formats."

Their emphasis is on their newest products for sale, Access 2010 and Excel 2010,

but they qualify it with "such as" and go on to mention its suitability for all
such file formats, which together imply that the download should work also for 
64-bit ODBC access to Access 2007 and Excel 2007 *.accdb and *.xlsx files.

The download is available in 32-bit and 64-bit versions.  If you're in a 
Windows 7 environment, then you'd download the 64-bit version.

If anyone finds out one way or the other (i.e., whether 64-bit Stata can work
with the 64-bit ODBC drivers that are installed by this download for accessing
Access/Excel 2007 files), then let the list know.  This topic's been popping up
on the list over the last year or so.

Joseph Coveney


*
*   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/