Re: st: ODBC: drop down menu vs. command line

[Thomas Speidel <thomas@tmbx.com>]

That's what I was missing!  I suppose using the drop down menu approach
estabilishes the connection to the selected database before the rest of 
the command is issued.

WISHLIST FOR STATA:
Is it possible in the future to include the dsn("") option when the 
command is generated as a result of using the drop down menu approach of 
selecting an odbc data source?


On Wed, 22 Feb 2012 12:58:27 -0500, Dimitriy V. Masterov wrote:

> Thomas,
>
> I think you need to include your dsn name like this:
>
> odbc load, dsn("DSN_NAME") table("PrePostControlBloodIds") clear
> lowercase noquote
>
> Let us know if that does not fix it.
>
> DVM
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search [1]
> * http://www.stata.com/support/statalist/faq [2]
> * http://www.ats.ucla.edu/stat/stata/ [3]

--
Thomas Speidel


Links:
------
[1] http://www.stata.com/help.cgi?search
[2] http://www.stata.com/support/statalist/faq
[3] 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/