Prev: ROC from proc Surveylogistic
Next: SAS capabilities for determining covariate coefficients
From: Ray on 10 May 2010 13:45
I need to get access to a SQL database but the DBAs will not allow any
type of ODBC or OLEDB connection. I was told I could access the data
using a terminal server. So I have been given the ability to logon to
the server via remote desktop. Is there any way I can use SAS to get
the data from this SQL Server like, say, via some emulator or
something like that? The server I am trying to get data from does not
have SAS on it.

Thanks for any help you can provide.

Ray Wallace
Washington State University
From: Patrick on 11 May 2010 08:01
A remote desktop means that they let you access the machine where the
database sits.

SAS could use either ODBC, OLEDB or SAS\Access to SQL Server to
communicate with the SQL serve - but as non of these possibilities are
desired you won't be able to access the SQL Server via SAS.

What one does in such a situation is to request a data extract (i.e. a
pipe delimited text file) from the DBA. SAS has for sure all
capabilities to read text files.
From: jclguy on 13 May 2010 15:31
Ray - if possible, try to find out what the dba's issue is - is it
simultaneous connections? Do you have SAS/Connect for SQL Server
licensed? If so, then you will not be using either ODBC or OLEDB - you
will just need an account with "read only" access.

Kind regards,

Stanley
From: Ray on 21 May 2010 13:02
Thanks for replying. I hadn't seen you posts until just now.

The issue is the university office who is the data steward does not
want ANYONE with a direct connection to the machine that has the SQL
server for security purposes. In the past, the DBA has emailed me a
copy of the SQL Server database and I have uploaded it into my own SQL
Server (which is a pain and results in not having up-to-date info).
But now they have upgraded to SQL Server 2008 and I am still on 2005
so the file they send is not compatible. I have asked for ODBC or
OLEDB connection but they are really against this idea.

I believe emailing the database is probably less secure than just
giving me ODBC access or just allowing my static IP address access to
the machine. I do not require anything more than read only access so
its not like I am going to change the data.

There are several web services which access this database and I
thought maybe I could have SAS access the data via a webservice as one
potential solution.

I was aslo thinking that there might be some terminal server emulator
software that I could have on my machine that I could have SAS 'talk'
to in order to get the access.

Also any help on how logically argue my position with this office
might help me get the ODBC access I need might be very helpful.

Thanks a bunch!

Ray


On May 13, 12:31 pm, jclguy <vogelman...(a)hotmail.com> wrote:
> Ray - if possible, try to find out what the dba's issue is - is it
> simultaneous connections? Do you have SAS/Connect for SQL Server
> licensed? If so, then you will not be using either ODBC or OLEDB - you
> will just need an account with "read only" access.
>
> Kind regards,
>
> Stanley

From: Ray on 21 May 2010 13:06
Oh and I do have SAS/Connect licensed. But how can I tell if it is
licensed for SQL Server?

On May 13, 12:31 pm, jclguy <vogelman...(a)hotmail.com> wrote:
> Ray - if possible, try to find out what the dba's issue is - is it
> simultaneous connections? Do you have SAS/Connect for SQL Server
> licensed? If so, then you will not be using either ODBC or OLEDB - you
> will just need an account with "read only" access.
>
> Kind regards,
>
> Stanley

 |  Next  |  Last
Pages: 1 2
Prev: ROC from proc Surveylogistic
Next: SAS capabilities for determining covariate coefficients