Statalist


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

Re: st: odbc load query


From   Nick Winter <nwinter@virginia.edu>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: odbc load query
Date   Fri, 08 Aug 2008 12:56:53 -0400

I just ran into this very problem last week, and found a solution in the Statalist Archives from last July.

The bottom line is to try adding the "noquote" option to your odbc load command.

Here's the old posting:

http://www.stata.com/statalist/archive/2008-07/msg00698.html

Stata developers: would it be useful to add reference to this problem in the online help for odbc, and/or to suggest the -noquote- option as a possible fix for r(682)?


-- Nick Winter




Murali Kuchibhotla wrote:

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/
--
--------------------------------------------------------------
Nicholas Winter                                 434.924.6994 t
Assistant Professor                             434.924.3359 f
Department of Politics                  nwinter@virginia.edu e
University of Virginia          faculty.virginia.edu/nwinter w
PO Box 400787, 100 Cabell Hall
Charlottesville, VA 22904

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