topic Re: SQL Server with Address Coder 10 in Data Management Questions

SQL Server with Address Coder 10

MatthewColeman — Thu, 19 Jan 2012 14:39:46 GMT

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.

Re: SQL Server with Address Coder 10

Jason_RobinsonRobinson — Thu, 19 Jan 2012 18:43:28 GMT

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.

Re: SQL Server with Address Coder 10

MatthewColeman — Fri, 20 Jan 2012 13:15:27 GMT

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.

Re: SQL Server with Address Coder 10

Jason_RobinsonRobinson — Fri, 20 Jan 2012 14:49:38 GMT

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.

Re: SQL Server with Address Coder 10

MatthewColeman — Fri, 20 Jan 2012 19:35:14 GMT

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.

Re: SQL Server with Address Coder 10

MatthewColeman — Mon, 23 Jan 2012 19:52:11 GMT

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.

Re: SQL Server with Address Coder 10

Jason_RobinsonRobinson — Tue, 24 Jan 2012 16:39:21 GMT

Can you post a pick of the data columns in your table? Wondering if their might be a data type issue here.

Re: SQL Server with Address Coder 10

MatthewColeman — Thu, 26 Jan 2012 19:13:22 GMT

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.

Re: SQL Server with Address Coder 10

Jason_RobinsonRobinson — Thu, 16 Feb 2012 16:25:09 GMT

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

Re: SQL Server with Address Coder 10

MatthewColeman — Thu, 01 Mar 2012 16:36:38 GMT

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.

Re: SQL Server with Address Coder 10

MatthewColeman — Wed, 18 Jul 2012 14:49:45 GMT

Its been awhile since I last posted in here. One of my co workers was able to link address coder 10 and SQL Server together to where the process runs automatically every night. It was a success, it just took us awhile to get things figured out. Thanks for all of your help.