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

st: RE: odbc load query

From   "Carlo Georges" <>
To   <>
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-----
[]On Behalf Of Murali
Sent: Freitag, 8. August 2008 18:33
Subject: st: odbc load query

      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;


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:

*   For searches and help try:

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