https://communities.sas.com/t5/Administration-and-Deployment/SAS-Viya-3-5-ODBC-MSSQL-Connection/m-p/855491#M25817 <P>You appear to have the Data Direct driver for MS SQL Server.<BR />You would also need SAS Access interface to ODBC</P> Wed, 25 Jan 2023 00:10:16 GMT Sajid01 2023-01-25T00:10:16Z https://communities.sas.com/t5/Administration-and-Deployment/SAS-Viya-3-5-ODBC-MSSQL-Connection/m-p/855052#M25808 <P>Hi to all,</P><P>&nbsp;</P><P>I installed Viya 3.5 environment. Then, when i try to connect data source via Environment Manager "Data" tab, i got following error;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="bursal_0-1674468142517.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/79606i4A4A1827D6CC954D/image-size/medium?v=v2&amp;px=400" role="button" title="bursal_0-1674468142517.png" alt="bursal_0-1674468142517.png" /></span></P><P>&nbsp;</P><P>Content of my odbc.ini file;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="bursal_1-1674468191422.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/79607i9C5EEC601D444035/image-size/medium?v=v2&amp;px=400" role="button" title="bursal_1-1674468191422.png" alt="bursal_1-1674468191422.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Mon, 23 Jan 2023 10:03:30 GMT https://communities.sas.com/t5/Administration-and-Deployment/SAS-Viya-3-5-ODBC-MSSQL-Connection/m-p/855052#M25808 bursalı 2023-01-23T10:03:30Z https://communities.sas.com/t5/Administration-and-Deployment/SAS-Viya-3-5-ODBC-MSSQL-Connection/m-p/855491#M25817 <P>You appear to have the Data Direct driver for MS SQL Server.<BR />You would also need SAS Access interface to ODBC</P> Wed, 25 Jan 2023 00:10:16 GMT https://communities.sas.com/t5/Administration-and-Deployment/SAS-Viya-3-5-ODBC-MSSQL-Connection/m-p/855491#M25817 Sajid01 2023-01-25T00:10:16Z https://communities.sas.com/t5/Administration-and-Deployment/SAS-Viya-3-5-ODBC-MSSQL-Connection/m-p/856112#M25853 <P>Thanks for your answer.&nbsp;</P><P>&nbsp;</P><P>I solved it by adding environment variables to relevant areas such as compute server config files etc.</P><P>&nbsp;</P><P>Just follow;&nbsp;<A href="https://documentation.sas.com/doc/en/calcdc/3.5/dplyml0phy0lax/p03m8khzllmphsn17iubdbx6fjpq.htm#n1okfvwiw804xbn1918a5jzwhskq" target="_blank">SAS Help Center: Configure Data Access</A></P> Sat, 28 Jan 2023 19:48:47 GMT https://communities.sas.com/t5/Administration-and-Deployment/SAS-Viya-3-5-ODBC-MSSQL-Connection/m-p/856112#M25853 bursalı 2023-01-28T19:48:47Z