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'

System.Net.WebException:

at System.Net.HttpWebRequest.GetResponse()

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.Xml.XmlTextReaderImpl.OpenUrl()

at System.Xml.XmlTextReaderImpl.Read()

at System.Xml.XmlTextReader.Read()

at System.Xml.XmlReader.MoveToContent()

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)

System.Exception:

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 ?