Help using Base SAS procedures

Question regarding DNS name for accessing a SQL Server through SAS UNIX

Reply
Occasional Contributor
Posts: 19

Question regarding DNS name for accessing a SQL Server through SAS UNIX

Hi,

I was trying to connect to a MS SQL server through SAS which is present in UNIX using passthrough. I wanted to know how do we configure the DNS name for this or is it ok if we just specify the Datasrc instead?

Thank you so much in Advance!
Super User
Posts: 5,435

Re: Question regarding DNS name for accessing a SQL Server through SAS UNIX

Your post does not tell much about your situation/configuration.
A good starting point is the configuration guide:

http://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/61994/PDF/default/config.pdf

/Linus
Data never sleeps
Super User
Posts: 10,041

Re: Question regarding DNS name for accessing a SQL Server through SAS UNIX



Hi.



 I think you can use ODBC to connect to sql server, Maybe DNS will not be used, you
can use IP address.



 



 



Ksharp



Trusted Advisor
Posts: 2,116

Re: Question regarding DNS name for accessing a SQL Server through SAS UNIX

ODBC is the only supported way. It's an add-on, so you will need to check with your site admin to see if you have it already or will need to license it.

Doc Muhlbaier
Duke
Ask a Question
Discussion stats
  • 3 replies
  • 124 views
  • 0 likes
  • 4 in conversation