topic Re: Problem with joining with a SQL Server data source. .DBF file works fine though? in Data Management Questions https://community.esri.com/t5/data-management-questions/problem-with-joining-with-a-sql-server-data-source/m-p/311054#M17760 <HTML><HEAD></HEAD><BODY><SPAN>On the shapefile, the field is of type TEXT, on the SQL Server table, the field is of type nvarchar(154)</SPAN></BODY></HTML> Fri, 06 Apr 2012 13:54:31 GMT DustinReagan 2012-04-06T13:54:31Z Problem with joining with a SQL Server data source. .DBF file works fine though? https://community.esri.com/t5/data-management-questions/problem-with-joining-with-a-sql-server-data-source/m-p/311052#M17758 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I'm using ArcMap 10.0.</SPAN><BR /><BR /><SPAN>I'm trying to inner join (with the join tool) a shape file with a table from an SQL Server data connection.&nbsp; It fails with 0 records.&nbsp; Howerver, when I export the table to a .DBF file, then do the same join, it works as expected!?</SPAN><BR /><BR /><SPAN>Any ideas?&nbsp; The data appears unchanged before and after the export.&nbsp; It's something under the hood, I expect...</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Dustin</SPAN></BODY></HTML> Wed, 04 Apr 2012 21:14:37 GMT https://community.esri.com/t5/data-management-questions/problem-with-joining-with-a-sql-server-data-source/m-p/311052#M17758 DustinReagan 2012-04-04T21:14:37Z Re: Problem with joining with a SQL Server data source. .DBF file works fine though? https://community.esri.com/t5/data-management-questions/problem-with-joining-with-a-sql-server-data-source/m-p/311053#M17759 <HTML><HEAD></HEAD><BODY><SPAN>What are the field types for the shapefile and for the SQL Server table that the join is based off of?</SPAN></BODY></HTML> Thu, 05 Apr 2012 10:44:22 GMT https://community.esri.com/t5/data-management-questions/problem-with-joining-with-a-sql-server-data-source/m-p/311053#M17759 JakeSkinner 2012-04-05T10:44:22Z Re: Problem with joining with a SQL Server data source. .DBF file works fine though? https://community.esri.com/t5/data-management-questions/problem-with-joining-with-a-sql-server-data-source/m-p/311054#M17760 <HTML><HEAD></HEAD><BODY><SPAN>On the shapefile, the field is of type TEXT, on the SQL Server table, the field is of type nvarchar(154)</SPAN></BODY></HTML> Fri, 06 Apr 2012 13:54:31 GMT https://community.esri.com/t5/data-management-questions/problem-with-joining-with-a-sql-server-data-source/m-p/311054#M17760 DustinReagan 2012-04-06T13:54:31Z Re: Problem with joining with a SQL Server data source. .DBF file works fine though? https://community.esri.com/t5/data-management-questions/problem-with-joining-with-a-sql-server-data-source/m-p/311055#M17761 <HTML><HEAD></HEAD><BODY><SPAN>Before doing the join click the validate join button in the bottom right of the screen, it could be you are using a reserved word or there are invalid characters in one of your field names in one or both of the tables.</SPAN><BR /><BR /><SPAN>Running the validate should give you a better idea of what is going on.</SPAN></BODY></HTML> Fri, 06 Apr 2012 15:32:48 GMT https://community.esri.com/t5/data-management-questions/problem-with-joining-with-a-sql-server-data-source/m-p/311055#M17761 KenCarrier 2012-04-06T15:32:48Z Re: Problem with joining with a SQL Server data source. .DBF file works fine though? https://community.esri.com/t5/data-management-questions/problem-with-joining-with-a-sql-server-data-source/m-p/311056#M17762 <HTML><HEAD></HEAD><BODY><SPAN>Sorry, I should have mentioned that I tried the "verify" functionality, and it gave no warnings or errors.</SPAN></BODY></HTML> Fri, 06 Apr 2012 18:05:50 GMT https://community.esri.com/t5/data-management-questions/problem-with-joining-with-a-sql-server-data-source/m-p/311056#M17762 DustinReagan 2012-04-06T18:05:50Z Re: Problem with joining with a SQL Server data source. .DBF file works fine though? https://community.esri.com/t5/data-management-questions/problem-with-joining-with-a-sql-server-data-source/m-p/311057#M17763 <HTML><HEAD></HEAD><BODY><SPAN>bump. still having this inexplicable problem.</SPAN></BODY></HTML> Tue, 10 Apr 2012 15:44:04 GMT https://community.esri.com/t5/data-management-questions/problem-with-joining-with-a-sql-server-data-source/m-p/311057#M17763 DustinReagan 2012-04-10T15:44:04Z Re: Problem with joining with a SQL Server data source. .DBF file works fine though? https://community.esri.com/t5/data-management-questions/problem-with-joining-with-a-sql-server-data-source/m-p/311058#M17764 <HTML><HEAD></HEAD><BODY><SPAN>Try importing your shapefile into a File Geodatabase and see if you experience the same behavior.</SPAN></BODY></HTML> Mon, 16 Apr 2012 10:07:02 GMT https://community.esri.com/t5/data-management-questions/problem-with-joining-with-a-sql-server-data-source/m-p/311058#M17764 JakeSkinner 2012-04-16T10:07:02Z