Bookmark and Share

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]

st: Fwd: Stata 13 ODBC problems


From   David Doody <[email protected]>
To   [email protected]
Subject   st: Fwd: Stata 13 ODBC problems
Date   Thu, 18 Jul 2013 11:03:27 -0700

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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index