topic ODBC error in Data Management Questions https://community.esri.com/t5/data-management-questions/odbc-error/m-p/275624#M15868 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #252c2f; font-family: Helvetica, Arial, Verdana, sans-serif; font-size: 13px; background-color: #ebf4f9;">Dear Members,</SPAN></P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P><SPAN style="color: #252c2f; font-family: Helvetica, Arial, Verdana, sans-serif; font-size: 13px; background-color: #ebf4f9;">I am trying to load a .dbf file (created with ArcGIS) into Stata using the "odbc load" command. However, Stata keeps reporting the following message:</SPAN></P><P><SPAN style="color: #252c2f; font-family: Helvetica, Arial, Verdana, sans-serif; font-size: 13px; background-color: #ebf4f9;">"The specified DSN contains an architecture mismatch between the Driver and Application"</SPAN></P><P><SPAN style="color: #555555; font-size: 14px; font-family: inherit;">I created my DSNs twice for both 64 and 32 bit applications but Stata cannot read the ArcGIS .dbf file in any case.<BR />Is anyone able to help?<BR /><BR />Thanks<BR /><BR />Kind regards,<BR /><BR />Sara Lazzaroni</SPAN></P></BODY></HTML> Mon, 12 Jan 2015 14:14:19 GMT SaraLazzaroni 2015-01-12T14:14:19Z ODBC error https://community.esri.com/t5/data-management-questions/odbc-error/m-p/275624#M15868 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #252c2f; font-family: Helvetica, Arial, Verdana, sans-serif; font-size: 13px; background-color: #ebf4f9;">Dear Members,</SPAN></P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P><SPAN style="color: #252c2f; font-family: Helvetica, Arial, Verdana, sans-serif; font-size: 13px; background-color: #ebf4f9;">I am trying to load a .dbf file (created with ArcGIS) into Stata using the "odbc load" command. However, Stata keeps reporting the following message:</SPAN></P><P><SPAN style="color: #252c2f; font-family: Helvetica, Arial, Verdana, sans-serif; font-size: 13px; background-color: #ebf4f9;">"The specified DSN contains an architecture mismatch between the Driver and Application"</SPAN></P><P><SPAN style="color: #555555; font-size: 14px; font-family: inherit;">I created my DSNs twice for both 64 and 32 bit applications but Stata cannot read the ArcGIS .dbf file in any case.<BR />Is anyone able to help?<BR /><BR />Thanks<BR /><BR />Kind regards,<BR /><BR />Sara Lazzaroni</SPAN></P></BODY></HTML> Mon, 12 Jan 2015 14:14:19 GMT https://community.esri.com/t5/data-management-questions/odbc-error/m-p/275624#M15868 SaraLazzaroni 2015-01-12T14:14:19Z Re: ODBC error https://community.esri.com/t5/data-management-questions/odbc-error/m-p/275625#M15869 <HTML><HEAD></HEAD><BODY><P>Hi Sara, </P><P></P><P>I assume you are using 64 bit Stata. If all you want is to load the data, I would use csv instead of dbf when loading data in 64 bit Stata.</P><P></P><P>Cheers,</P><P>Mike</P></BODY></HTML> Tue, 13 Jan 2015 03:25:39 GMT https://community.esri.com/t5/data-management-questions/odbc-error/m-p/275625#M15869 MikeCusi 2015-01-13T03:25:39Z