Addresses with apartment numbers have some issues...
The following work: Apartment B32 or apt. B32
The following don't work: Apartment #B32, apt B32, apt #B32 (in fact, the pound (#) sign causes no results to be returned)
It seems like I will have to scan each address for an apartment number before sending it to the stored procedure, but there are lots of variations that people use
PO Boxes are also causing some issues.
I like the article and the example.
I've tried to install it on my local sql2005STD instance wich has clr enabled and my testdb is trustworthy.
The vb.net version as well as the c#.net version do not work
I did add //Catch any errors here throw new Exception("mynewexception", ex);
When I execute the url in internet explorer I receive the correct results.
When executed with the sproc it says :
Msg 6522, Level 16, State 1, Procedure spclr_GeocodingC, Line 0
A .NET Framework error occurred during execution of user defined routine or aggregate 'spclr_GeocodingC':
System.Exception: mynewexception---> System.Net.WebException: The remote name could not be resolved: 'api.local.yahoo.com'
at System.Xml.XmlDownloadManager.GetNonFileStream(Uri uri, ICredentials credentials)
at System.Xml.XmlDownloadManager.GetStream(Uri uri, ICredentials credentials)
at System.Xml.XmlUrlResolver.GetEntity(Uri absoluteUri, String role, Type ofObjectToReturn)
at System.Xml.XmlTextReaderImpl.OpenUrlDelegate(Object xmlResolver)
at System.Threading.CompressedStack.runTryCode(Object userData)
at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
at System.Threading.CompressedStack.Run(CompressedStack compressedStack, ContextCallback callback, Object state)
at System.Data.DataSet.ReadXml(XmlReader reader, Boolean denyResolving)
at System.Data.DataSet.ReadXml(XmlReader reader)
at StoredProcedures.spclr_GeocodingC(String Address, String City, String State, String appid)
This server is running with the same account I am logged in
Any hints ?
Here it is ... my vbform :
form fields : streettxt , citytxt, statetxt , datagridview Resultsdgvform button : CallWebServicebtn
here's the code :
ds = SPCLR_Geocode(Streettxt.Text.ToString, Citytxt.Text.ToString, Statetxt.Text.ToString,
Resultdgv.DataSource = ds.Tables(0)
Address = Address.Replace(
it also gives an error, but for some proxi thing ???
System.Net.WebException: The remote server returned an error: (407) Proxy Authentication Required.
at GeocodingWIN.FormStartup.SPCLR_Geocode(String Address, String City, String State, String appid) in P:\Documents\Visual Studio 2005\Projects\Geocoding\GeocodingWIN\FormStartup.vb:line 56"
Being a dba that's trying to code a bit ... HEEELLLLPP
once again, internet exporer with the same url works fine