st: Fwd: Stata 13 ODBC problems

[David Doody <doody.david@gmail.com>]

Greetings,

I've been working with Stata tech support, but haven't come up with a
solution that works yet, so I thought I'd see if other users are
having similar problems?

I am having difficulty getting all my ODBC links to work in Stata 13.
If I use 64-bit Stata, then I can't read Access databases, since we
have 32-bit Office installed, and 64-bit Stata requires the 64-bit
driver.

Question: Has anyone successfully installed the 64-bit Office driver
*then* installed 32-bit Office, and then had 64-bit Stata work for
them?  We tried this in Stata 12 and it didn't work for us, so we went
ahead and used 32-bit Stata.

Which brings me to my next problem.  SQL databases are problematic in
32-bit Stata 13.  I can read some of them, but others either crash
Stata or give the "op. sys. refuses to provide memory" error message.
I tried updating the SQL ODBC driver, and was able to read a
previously-problematic file.  But I still get the errors/crashes with
other files.  I don't think it's a size issue.  The ones I know don't
work are 8 and 22 MB.

Question:  Have other 32-bit Stata 13 users had any new difficulties
reading SQL databases after upgrading?  This was all working in Stata
12.

Using Windows 7, 4GB RAM, Intel Core2Duo processor, 2.93GHz.

Thanks for any help you can provide!
Dave
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/