Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: RE: odbc load query


From   "Murali Kuchibhotla" <muralik@iastate.edu>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: odbc load query
Date   Fri, 8 Aug 2008 12:08:57 -0500 (CDT)

Hi Carlo,
         Tried it; doesn't work though. I still get the same error 
message.Thanks for the suggestion though.

Murali

> Try the command
> "set memory 15000"
> 
> I had problems connecting to acces databases with more than 140000 entries,
> You have to close STATA
> restart it , your first command before loading any data must be the set
> memory instruction
> 
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu]On Behalf Of Murali
> Kuchibhotla
> Sent: Freitag, 8. August 2008 18:33
> To: statalist@hsphsun2.harvard.edu
> Subject: st: odbc load query
> 
> 
> Hello,
>       I am having problems trying to connect to my odbc dsn. When I try to
> load an excel spreadsheet through the odbc, I obtain the following message:
> 
>  set debug on
> 
>  odbc load , table("07-01-08") dsn("dailysnap_2008")
> Connection Parameters (IN): DSN=dailysnap_2008;
> Connection Parameters (OUT): DSN=dailysnap_2008;
> 
> r(682);
> 
> I have the driver for dailysnap_2008 correctly identified. Also, r(682)
> suggests that I might have insufficient permission to connect to the
> datasource, which is not the case here. Any suggestions? Thanks.
> 
> 
> Murali Kuchibhotla
> 
> 
> *
> *   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/
> 
> *
> *   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/
> 


Murali Kuchibhotla
Department of Economics
Iowa State University
Office:75,Heady
Phone:515-294-5452


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



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index