topic Reading .XML files into SAS Dataflux DMS v2.5 in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/Reading-XML-files-into-SAS-Dataflux-DMS-v2-5/m-p/217189#M5308 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am trying to set up an ODBC data link to read a .XML file but am getting the following message that the FXXML27S.DLL could not be found - along with a system error 126 (see below)</P><P></P><P>Can anybody advise if this is a standard add-in for SAS (and we should have it) or is licence dependent</P><P></P><P>thanks</P><P>Nigel</P><P><IMG alt="xml error.JPG" class="jive-image" src="https://communities.sas.com/legacyfs/online/10505_xml error.JPG" /></P></BODY></HTML> Tue, 19 May 2015 15:41:10 GMT NigelLight 2015-05-19T15:41:10Z Reading .XML files into SAS Dataflux DMS v2.5 https://communities.sas.com/t5/SAS-Data-Management/Reading-XML-files-into-SAS-Dataflux-DMS-v2-5/m-p/217189#M5308 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am trying to set up an ODBC data link to read a .XML file but am getting the following message that the FXXML27S.DLL could not be found - along with a system error 126 (see below)</P><P></P><P>Can anybody advise if this is a standard add-in for SAS (and we should have it) or is licence dependent</P><P></P><P>thanks</P><P>Nigel</P><P><IMG alt="xml error.JPG" class="jive-image" src="https://communities.sas.com/legacyfs/online/10505_xml error.JPG" /></P></BODY></HTML> Tue, 19 May 2015 15:41:10 GMT https://communities.sas.com/t5/SAS-Data-Management/Reading-XML-files-into-SAS-Dataflux-DMS-v2-5/m-p/217189#M5308 NigelLight 2015-05-19T15:41:10Z Re: Reading .XML files into SAS Dataflux DMS v2.5 https://communities.sas.com/t5/SAS-Data-Management/Reading-XML-files-into-SAS-Dataflux-DMS-v2-5/m-p/217190#M5309 <HTML><HEAD></HEAD><BODY><P>Hi Nigel, the DM Studio user guide has a usage note that might help:</P><P></P><P><A href="http://support.sas.com/documentation/onlinedoc/dfdmstudio/2.6/dmpdmsug/Content/dfDMStd_T_DSN_Usage.html#head_xml" title="http://support.sas.com/documentation/onlinedoc/dfdmstudio/2.6/dmpdmsug/Content/dfDMStd_T_DSN_Usage.html#head_xml">Data Connection Usage Notes</A></P><P></P><P>It says:</P><P></P><H3><A id="head_xml" name="head_xml"></A>ODBC XML Connections</H3><H5><A id="usage_xml_job" name="usage_xml_job"></A>How can I read an XML file in a data job?</H5><P>Due to the limitations of the ODBC 32-bit XML driver, we recommend that you use the <A href="http://support.sas.com/documentation/onlinedoc/dfdmstudio/2.6/dmpdmsug/Content/dfU_PFInput_XML.html">XML Input node</A> to read an XML file in a data job.</P></BODY></HTML> Tue, 19 May 2015 17:30:09 GMT https://communities.sas.com/t5/SAS-Data-Management/Reading-XML-files-into-SAS-Dataflux-DMS-v2-5/m-p/217190#M5309 DaveR_SAS 2015-05-19T17:30:09Z Re: Reading .XML files into SAS Dataflux DMS v2.5 https://communities.sas.com/t5/SAS-Data-Management/Reading-XML-files-into-SAS-Dataflux-DMS-v2-5/m-p/217191#M5310 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Thanks for the info - I have followed the link and it seems that I need to download an .XML mapper</P><P></P><P>Regards</P><P>Nige</P></BODY></HTML> Wed, 20 May 2015 10:11:00 GMT https://communities.sas.com/t5/SAS-Data-Management/Reading-XML-files-into-SAS-Dataflux-DMS-v2-5/m-p/217191#M5310 NigelLight 2015-05-20T10:11:00Z Re: Reading .XML files into SAS Dataflux DMS v2.5 https://communities.sas.com/t5/SAS-Data-Management/Reading-XML-files-into-SAS-Dataflux-DMS-v2-5/m-p/217192#M5311 <HTML><HEAD></HEAD><BODY><P>Could this be the answer - non-compatibility? <A class="active_link" href="https://support.microsoft.com/en-us/kb/260558">https://support.microsoft.com/en-us/kb/260558</A></P><P></P><P>No luck in getting this to work - back to plan B (save it as a delimited .txt file) which seems to work</P></BODY></HTML> Thu, 21 May 2015 15:51:14 GMT https://communities.sas.com/t5/SAS-Data-Management/Reading-XML-files-into-SAS-Dataflux-DMS-v2-5/m-p/217192#M5311 NigelLight 2015-05-21T15:51:14Z