SQL Server with Address Coder 10

1373
10
01-19-2012 06:39 AM
MatthewColeman
New Contributor II
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.
Tags (2)
0 Kudos
10 Replies
Jason_RobinsonRobinson
Esri Regular Contributor
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.


Matthew,

Which version of SQL Server are you using?  There does appear to be an issue with SQL Server when attempting to write back to the input table instead of a new one under Output.

Regards,
Jason R.
0 Kudos
MatthewColeman
New Contributor II
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.
0 Kudos
Jason_RobinsonRobinson
Esri Regular Contributor
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.


Mathew,

Do you receive error messages and if so could you attach any screen shots?  Any details as to how it does not work would help greatly.

Regards,
Jason R.
0 Kudos
MatthewColeman
New Contributor II
Yes I can send you screenshots. It will be on Monday (1/23) when I am able to get the screenshots posted. I am running an update on my computer.
0 Kudos
MatthewColeman
New Contributor II
Here are the screenshots of my problem. Hope this helps.

1)[ATTACH=CONFIG]11383[/ATTACH]
2)[ATTACH=CONFIG]11384[/ATTACH]
3)[ATTACH=CONFIG]11386[/ATTACH]
4) [ATTACH=CONFIG]11385[/ATTACH]

Images 1 and 2 are the input and output. The 3 image is the error message I get after I put the information in the input box. The last image (4) is the fields tab. I am not able to select any fields from the drop down arrows for address, city, zip and so on.
0 Kudos
Jason_RobinsonRobinson
Esri Regular Contributor
Can you post a pick of the data columns in your table?  Wondering if their might be a data type issue here.
0 Kudos
MatthewColeman
New Contributor II
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.
0 Kudos
Jason_RobinsonRobinson
Esri Regular Contributor
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.


Matthew,

The error could be related to Address Coder not knowing what to do with the "geography" type.  Speaking with the developer when they added SQL Server support years ago they stuck to types that would convert to a csv file generally.  Try creating a copy of this table without the geography type columns like GEOGeography to see if it eliminates the error you encounter and successfully processes the file.  If it does process after removing those columns I can submit a bug for this.

Regards,
Jason
0 Kudos
MatthewColeman
New Contributor II
Hi Jason,

Sorry for the late reply. I am currently working on the address coder application with my manager and we working together on connecting address coder with SQL server. We will keep you posted on how this process is working.
0 Kudos