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.
... View more