Re: st: RE: RE: Fwd: Stata 13 ODBC problems

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

Thank you all for the suggestions, and I love the new meaning of the
acronym ODBC. :)

Kerry at Stata tech support was able to find me a solution.  It *is*
possible to install the 64-bit Access ODBC driver on a machine where
32-bit Office is installed. (And no, installing 64-bit Office was not
an option, per our IT folks - too many complications and they won't
consider it.)

http://stackoverflow.com/questions/7116019/hand-install-of-64-bit-ms-access-odbc-drivers-when-32-bit-office-is-present

So far, this has allowed me to set up new ODBC links to my Access data
files, and 64-bit Stata already had no problems reading my SQL
databases.  I haven't fully tested yet but everything I've tried has
worked so far.

Very pleased to be able to use 64-bit Stata 13 for all my tasks.

Thanks!
Dave



On Fri, Jul 19, 2013 at 12:18 PM, Simmons, Nicole <nsimmons@jhsph.edu> wrote:
> But, you need to use the 32-bit version of StatTransfer even if you have a 64-bit computer!!! It works fine.
>
> Nicole Simmons
> Johns Hopkins University
>
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Gary M McClelland
> Sent: Friday, July 19, 2013 1:37 PM
> To: statalist@hsphsun2.harvard.edu
> Subject: st: RE: Fwd: Stata 13 ODBC problems
>
> 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/
>
> *
> *   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/