topic Re: How can I set up ODBC connection from within SAS Studio in New SAS User

How can I set up ODBC connection from within SAS Studio

9Squirrels — Mon, 20 May 2019 04:23:55 GMT

We have a new SAS VIYA environment set up on Windows, my access to it is via SAS Studio in a web browser.

I have some legacy code to run which uses ODBC libnames to connect to SQL Server databases, and we have SAS/ACCESS for ODBC installed.

How do I set up the ODBC connection so that the libname can point to it? Is there a tool within SAS Studio to allow me to do that or will I need to log into the Windows environment on the server that SAS is installed on to set up the ODBC connection there?

I've got the SAS side of it set up fine:

libname ABS2016 ODBC datasrc='ABSGEO2016';

I just need to know how I go about setting up the ODBC connection. On the old server I had access to the OS to be able to do this, but not on the new one.

Thanks

Chris.

Re: How can I set up ODBC connection from within SAS Studio

SASKiwi — Mon, 20 May 2019 04:53:01 GMT

The good news with running on Windows makes it easy to define ODBC connections without using data sources at all. You can specify everything in the connection string. What database(s) are you connecting to? If it is SQL Server this post may be helpful:

https://communities.sas.com/t5/SAS-Data-Management/Example-of-DSN-less-SQL-Server-connection-from-Linux/m-p/349245/highlight/true#M10386

Re: How can I set up ODBC connection from within SAS Studio

9Squirrels — Mon, 20 May 2019 06:14:25 GMT

Thanks @SASKiwi , unfortunately as I don't have access to the OS, the link isn't much help as it requires you to add/update settings files to the SAS install.

However your note that I could set up all the details within the libname ODBC statement helped me look elsewhere and I eventually found some examples here:

http://support.sas.com/kb/52/777.html

And that's fixed my problem

75         libname gnaf odbc noprompt="driver=SQL Server;
 76                                      server=blahblah;
 77                                      database=GNAF_AUG2018;
 78                                      Trusted_Connection=yes"
 79                           schema=dbo;
 NOTE: Libref GNAF was successfully assigned as follows: 
       Engine:        ODBC 
       Physical Name:

Cheers

Re: How can I set up ODBC connection from within SAS Studio

SASKiwi — Mon, 20 May 2019 07:04:54 GMT

Cool. Your solution is exactly what we do. Glad to be able to help.