Problem with joining with a SQL Server data source. .DBF file works fine though?

[DustinReagan]

Hi,

I'm using ArcMap 10.0.

I'm trying to inner join (with the join tool) a shape file with a table from an SQL Server data connection.  It fails with 0 records.  Howerver, when I export the table to a .DBF file, then do the same join, it works as expected!?

Any ideas?  The data appears unchanged before and after the export.  It's something under the hood, I expect...

Thanks,
Dustin

[JakeSkinner]

What are the field types for the shapefile and for the SQL Server table that the join is based off of?

[DustinReagan]

On the shapefile, the field is of type TEXT, on the SQL Server table, the field is of type nvarchar(154)

[KenCarrier]

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.

Running the validate should give you a better idea of what is going on.

[DustinReagan]

Sorry, I should have mentioned that I tried the "verify" functionality, and it gave no warnings or errors.

[DustinReagan]

bump. still having this inexplicable problem.

[JakeSkinner]

Try importing your shapefile into a File Geodatabase and see if you experience the same behavior.