st: RE: Fwd: Stata 13 ODBC problems

[Gary M McClelland <gmac@northwestern.edu>]

Hi,

I avoid ODBC, especially that native to Windows.  Try a third-party ODBC product, maybe?  I cannot recommend one.  

Or, if you don't need live data, maybe use StatTransfer.  You can call it in batch mode with the Stata "shell" command [also called from Stata as "!"].  I've written a little program for general use in our group that seeks StatTransfer in it's obscure locations and passes the parameters for the transfer to StatTransfer batch processor st.exe.  This works on 64 bit Windows and Office, 32 bit and any combination we've managed to install.  In my experience, StatTransfer is pretty robust to OS issues.

 G

ODBC=="Oh Darn, Better Call support."

Gary M. McClelland, PhD
Department of Psychiatry
Feinberg School of Medicine
Northwestern University
(312) 503-3504
  Please consider the environment before printing this e-mail. 

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of David Doody
Sent: Thursday, July 18, 2013 1:03 PM
To: statalist@hsphsun2.harvard.edu
Subject: st: Fwd: Stata 13 ODBC problems

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/

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