topic Re: SQL connect from sas not working in SAS Data Management

SQL connect from sas not working

vijayRyDot — Sat, 16 Mar 2019 09:07:20 GMT

Hi,

I have installed trial versino of SAS and trying to connect SQL Server ODBC using Data Sources but it gives an error.

There was a problem testing the connection: License check failed for feature 'Data Connector to ODBC': The feature is not licensed.View details (ATTACHED SCREENSHOT)

Is it not allowed to connect SQL Server ODBC using Data sources in SAS Or am I missing something like installation, setting or else ?

Re: SQL connect from sas not working

VDD — Sat, 16 Mar 2019 15:07:00 GMT

Trial versions of software are just that trial.

What trial version of SAS are you trying to use SAS access feature with?

Re: SQL connect from sas not working

SASKiwi — Sun, 17 Mar 2019 19:13:39 GMT

Run this: proc setinit; run;

If the SAS log does not list SAS/ACCESS to ODBC then you are not licensed for this. You could contact your SAS account manager to see if it can be included.

Re: SQL connect from sas not working

vijayRyDot — Mon, 18 Mar 2019 05:42:02 GMT

I ran the command. "proc setinit; run;" and don't have SAS/ACCESS to ODBC listed. I would have to contact SAS account manager. Appreciate your help

Re: SQL connect from sas not working

vijayRyDot — Wed, 20 Mar 2019 09:12:48 GMT

SAS® Visual Data Mining and Machine Learning on SAS® Viya. I downloaded this Trial