Bug
OLE DB connections using the SQL Server Native Client 10.0 as a provider do not work in ArcGIS Server 10.0 services.
| Bug ID Number | NIM063000 |
|---|---|
| Submitted | November 22, 2010 |
| Last Modified | April 2, 2025 |
| Applies to | ArcGIS Server (.NET) |
| Version found | 10.0 |
| Operating System | Windows OS |
| Operating System Version | 2008 64 Bit |
| Status | Will Not Be Addressed |
Additional Information
We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.Workaround
If the data is added using a Query layer, that table can be properly used in a map service.Another workaround is to set up the connection to the database using the Windows "Data Sources (ODBC)" dialog (in the System DNS tab) on the ArcMap computer (used to author the map) and all SOC machines. The name of the data source must be the same on all computers. Instead of using the SQL Server Native Client 10.0, create an OLE DB connection using "Microsoft OLE DB Provider for ODBC Drivers" as the provider.Steps to Reproduce
Bug ID: NIM063000
Software:
- ArcGIS Server (.NET)
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App