topic Re: Odbc Data Source configuration in Administration and Deployment

Odbc Data Source configuration

kcoley — Sun, 07 Jun 2020 17:07:25 GMT

Does anyone no what server configuration files sas viya data explorer use? Apparently it does not read the same files as studio. Data explorer is unable to find my ODBC drivers while studio connects. It is a new install and im running a linux environment

Re: Odbc Data Source configuration

Patrick — Mon, 08 Jun 2020 01:04:21 GMT

Have you already seen below links?

https://documentation.sas.com/?docsetId=dplyml0phy0lax&docsetTarget=p1x1jry6iz5bn4n1hdb5e859eikg.htm&docsetVersion=3.4&locale=en

https://communities.sas.com/t5/Administration-and-Deployment/SAS-VIYA-can-t-connect-to-ODBC-Driver/td-p/513841

Re: Odbc Data Source configuration

kcoley — Mon, 08 Jun 2020 01:33:51 GMT

I have not. I just looked over it. Do you no if Data Connector to ODBC is licensed separately or is it the same as SAS/ACCESS to ODBC?

Re: Odbc Data Source configuration

SASKiwi — Mon, 08 Jun 2020 03:08:57 GMT

@kcoley - AFAIK, Viya comes with a bundle of connectors to common external databases as part of a standard package. I don't believe they are priced separately. Someone from SAS might like to confirm.

Re: Odbc Data Source configuration

AnandVyas — Mon, 08 Jun 2020 03:28:16 GMT

SAS Data Connector reference in SAS is now as a casLib. IMHO License wise it should be the same.

Re: Odbc Data Source configuration

kcoley — Mon, 08 Jun 2020 11:26:35 GMT

Okay. Would you happen to have a configuration document for Data Connector? It looks like that is what is not working and i dont remember ever configuring that. I did do acess to odbc and that connects fine.