Statalist


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

st: RE: odbc load query


From   "Carlo Georges" <georgesc@pt.lu>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: odbc load query
Date   Fri, 8 Aug 2008 18:53:29 +0200

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/



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