topic Configuring SAS/ACCESS and Data Connectors(MYSQL, SAP HANA) for SAS Viya 4 in New SAS User https://communities.sas.com/t5/New-SAS-User/Configuring-SAS-ACCESS-and-Data-Connectors-MYSQL-SAP-HANA-for/m-p/912746#M40875 <P>Hi Team,</P><P>&nbsp;</P><P><SPAN><SPAN class="">Followed the below document to configure SAS/ACCESS and Data Connectors for SAS Viya 4:</SPAN></SPAN></P><P><A href="https://support.sas.com/documentation/installcenter/viya/SASViyaReadMe.htm#configuring_sasaccess_and_data_connectors_for_sas_viya_4" target="_blank" rel="noopener">https://support.sas.com/documentation/installcenter/viya/SASViyaReadMe.htm#configuring_sasaccess_and_data_connectors_for_sas_viya_4</A></P><P>&nbsp;</P><P>Encountering below error's for SAS/ACCESS Interface to MYSQL, SAP HANA.</P><P>&nbsp;</P><P><STRONG>MYSQL:</STRONG></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Narendra_P_1-1706017591806.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/92899i6F3B3C0439D7FDA6/image-size/medium?v=v2&amp;px=400" role="button" title="Narendra_P_1-1706017591806.png" alt="Narendra_P_1-1706017591806.png" /></span></P><P><STRONG>SAP HANA:</STRONG></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Narendra_P_0-1706017525320.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/92898i7B2A518CED3F6001/image-size/medium?v=v2&amp;px=400" role="button" title="Narendra_P_0-1706017525320.png" alt="Narendra_P_0-1706017525320.png" /></span></P><P>sas-access.properties path's:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Narendra_P_2-1706035623033.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/92918i5F0B05B81E3F24D2/image-size/medium?v=v2&amp;px=400" role="button" title="Narendra_P_2-1706035623033.png" alt="Narendra_P_2-1706035623033.png" /></span></P><P>&nbsp;</P><P>Added DSNs in&nbsp; SAS/ACCESS connections, the data sources are defined within an odbc.ini configuration file.&nbsp; Please find the attached odbc file.</P><P>&nbsp;</P><P>Could you please suggest on this issue?</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 23 Jan 2024 18:56:54 GMT Narendra_P 2024-01-23T18:56:54Z Configuring SAS/ACCESS and Data Connectors(MYSQL, SAP HANA) for SAS Viya 4 https://communities.sas.com/t5/New-SAS-User/Configuring-SAS-ACCESS-and-Data-Connectors-MYSQL-SAP-HANA-for/m-p/912746#M40875 <P>Hi Team,</P><P>&nbsp;</P><P><SPAN><SPAN class="">Followed the below document to configure SAS/ACCESS and Data Connectors for SAS Viya 4:</SPAN></SPAN></P><P><A href="https://support.sas.com/documentation/installcenter/viya/SASViyaReadMe.htm#configuring_sasaccess_and_data_connectors_for_sas_viya_4" target="_blank" rel="noopener">https://support.sas.com/documentation/installcenter/viya/SASViyaReadMe.htm#configuring_sasaccess_and_data_connectors_for_sas_viya_4</A></P><P>&nbsp;</P><P>Encountering below error's for SAS/ACCESS Interface to MYSQL, SAP HANA.</P><P>&nbsp;</P><P><STRONG>MYSQL:</STRONG></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Narendra_P_1-1706017591806.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/92899i6F3B3C0439D7FDA6/image-size/medium?v=v2&amp;px=400" role="button" title="Narendra_P_1-1706017591806.png" alt="Narendra_P_1-1706017591806.png" /></span></P><P><STRONG>SAP HANA:</STRONG></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Narendra_P_0-1706017525320.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/92898i7B2A518CED3F6001/image-size/medium?v=v2&amp;px=400" role="button" title="Narendra_P_0-1706017525320.png" alt="Narendra_P_0-1706017525320.png" /></span></P><P>sas-access.properties path's:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Narendra_P_2-1706035623033.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/92918i5F0B05B81E3F24D2/image-size/medium?v=v2&amp;px=400" role="button" title="Narendra_P_2-1706035623033.png" alt="Narendra_P_2-1706035623033.png" /></span></P><P>&nbsp;</P><P>Added DSNs in&nbsp; SAS/ACCESS connections, the data sources are defined within an odbc.ini configuration file.&nbsp; Please find the attached odbc file.</P><P>&nbsp;</P><P>Could you please suggest on this issue?</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 23 Jan 2024 18:56:54 GMT https://communities.sas.com/t5/New-SAS-User/Configuring-SAS-ACCESS-and-Data-Connectors-MYSQL-SAP-HANA-for/m-p/912746#M40875 Narendra_P 2024-01-23T18:56:54Z Re: Configuring SAS/ACCESS and Data Connectors(MYSQL, SAP HANA) for SAS Viya 4 https://communities.sas.com/t5/New-SAS-User/Configuring-SAS-ACCESS-and-Data-Connectors-MYSQL-SAP-HANA-for/m-p/912748#M40876 You'll better served opening a SAS Tech Support track for this. Tue, 23 Jan 2024 19:02:04 GMT https://communities.sas.com/t5/New-SAS-User/Configuring-SAS-ACCESS-and-Data-Connectors-MYSQL-SAP-HANA-for/m-p/912748#M40876 AhmedAl_Attar 2024-01-23T19:02:04Z