I have started to use Address Coder 10 as one of my primary sources of geocoding addresses. I have been able to use Address Coder with Microsoft Access. I have tried to use Address Coder with SQL server and I do not have any luck with it. It seems that the only way I can get Address Coder to work is using Microsoft Access. I haven't seen a whole lot of blogs or posts about anyone using Address Coder 10. I am curious to see if anyone else on the forums has used Address Coder and what they have thought about it and how successful they are with Address Coder.
I am currently using the 2008 edition of SQL server. The company I work for is going to move over to SQL 2008 R2 this year.
Here is the data I am using. I am using the following columns for the address coder:
SourceAddressLine1
SourceAddressLine2
SourceAddressCity
SourceAddressState
SourceAddressZipCode
I have attached the SQL table (in a spreadsheet) I use to try and connect to address coder.