Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: ODBC and relational database


From   "Farmer, Robert M" <Robert.Farmer3@med.va.gov>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: ODBC and relational database
Date   Wed, 9 Jun 2004 12:15:23 -0400

Generally speaking, ODBC connections are handled by the Operating System.  Stata specifically states that only Windows is supported at this time.  

Assuming that you are using windows, under Start you'll find the Control Panel.  In the control panel you'll find Administrative Tools.  Under Administrative tools you 'll find Data Sources (ODBC)  ... or something of that nature, the words change from system to system.

This Data Sources is where you'll set up the ODBC call for whatever product your using.  It's not hard, and not really complicated, and there should be documentation on the system.  Once you have the DataSource set up, the rest is simply telling Stata what table the data you want resides in and the variables (columns) within the table.  It's one of those things where the first 3 times you tear your hair out, but after that, it's easy.

There are several forums that deal with connectivity issues.  Most are probably too technical for you to use on a daily basis, but they WILL answer beginners questions with where to find information.  You might try http://searchvb.techtarget.com/forums/0,289802,sid8,00.html for a start.  I don't know them, but layout seems to indicate that they know what they are doing.

Good Luck
RFarmer
-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu]On Behalf Of Kathryn Jervis
Sent: Wednesday, June 09, 2004 10:59 AM
To: statalist@hsphsun2.harvard.edu
Subject: st: ODBC and relational database


I am looking for a book or journal article that explains how to use
Stata with relational databases.  I think that I use the ODBC command,
and I have read that reference online, but still I am uncertain about
how to get just the data that I need from the database.

Thanks

Kathryn J. Jervis, Ph.D.
Washington and Lee University
Williams School of Commerce, Economics and Politics
Lexington, VA 24450
mailto:jervisk@wlu.edu
Office: 540.458.8628
Fax: 540.458.8639
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   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