Statalist The Stata Listserver


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

st: Using ODBC


From   David Winter <d.l.winter@bham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: Using ODBC
Date   Wed, 21 Feb 2007 14:02:18 +0000

Dear Statalisters,

I use SQL server 2000 to store my data.  I have set up DSNs to the various databases and pushed them to the workstations on my network.  The SQL server security settings are different for each user and database.  I have recently discovered the -odbc- command.  My questions are:

Are the security settings from the underlying SQL tables inherited by Stata.  For example, I have a database for reference with read-only tables. Will Stata still allow records/variables to be added or data overwritten?

How does the -odbc load- command work? It appears to load the data as a read-only view.

What I want to be able to do allow users to load a reference file, create new variables and run analyses but not alter the original data in any way.

Best wishes,

Dave

*********************************************************** 
Mr David L. Winter, HNC 
IT Manager
Centre for Childhood Cancer Survivor Studies 
Department of Public Health & Epidemiology 
University of Birmingham 
Edgbaston 
Birmingham 
B15 2TT 
UK 
tel: +44 (0)121 4146766 
fax: +44 (0)121 4147923
email: d.l.winter@bham.ac.uk
website: www.bccss.bham.ac.uk
*********************************************************** 

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