SQL 2008 CLR和Bing Maps
|
我已经开发了一个小型C#应用程序,可以使用配置为服务引用的Bing地理编码服务对地址表进行地理编码。我已经加载了程序集,但是当我尝试通过存储过程调用它时,收到以下错误:
A .NET Framework error occurred during execution of user-defined routine or aggregate \"Geocoder\":
System.InvalidOperationException: Could not find endpoint element with name \'BasicHttpBinding_IGeocodeService\' and contract \'BingMapsGeo.IGeocodeService\' in the ServiceModel client configuration section. This might be because no configuration file was found for your application, or because no endpoint element matching this name could be found in the client element.
System.InvalidOperationException:
at System.ServiceModel.Description.ConfigLoader.LoadChannelBehaviors(ServiceEndpoint serviceEndpoint, String configurationName)
at System.ServiceModel.ChannelFactory.InitializeEndpoint(String configurationName, EndpointAddress address)
at System.ServiceModel.ChannelFactory`1..ctor(String endpointConfigurationName, EndpointAddress remoteAddress)
at System.ServiceModel.ChannelFactory`1..ctor(String endpointConfigurationName)
at System.ServiceModel.EndpointTrait`1.CreateSimplexFactory()
at System.ServiceModel.EndpointTrait`1.CreateChannelFactory()
at System.ServiceModel.ClientBase`1.CreateChannelFactoryRef(EndpointTrait`1 endpointTrait)
at System.ServiceModel.ClientBase`1.InitializeChannelFactoryRef()
at System.ServiceModel.ClientBase`1..ctor(String endpointConfigurationName)
at Geocoder.BingMapsGeo.GeocodeServiceClient..ctor(String endpointConfigurationName)
at Geocoder.UserDefinedFunctions.geocode(SqlString AddressLine, SqlString City, SqlString State, SqlString Zip)
我相当确定实际的C#程序集是正确的,但是我认为我在实际的Web服务方面缺少一些东西。
我一直在到处寻找解决方案,但是没有找到似乎可行的解决方案。
我正在Server 2008R2上运行带有最新补丁程序和.NET版本的SQL 2008R2。
任何想法都将受到欢迎。
没有找到相关结果
已邀请:
3 个回复
鲁釜头
疼嘶桐
完趣镐