I am a vendor working on some customer problems. One of my inititives is to backup their existing Microsoft SQL server 2008 R2 64-bit databases, including some arcgis ones. I have been successfully able to restore databases, but when my product starts any GIS-related function gives an application error that the "Direct Connect driver release isn't compatible with ArcSde database instance release" I've included the entire text of the Windows application log error.
As I understand it, this error is thrown when a version of ARCSDE is incompatible with ARCGIS Runtime Engine. When running the patchfinder.exe utlility, both ArcGIS Engine Runtime 9.3 Service Pack 1 and ArcGIS ArcSDE for SQL Server 9.3 Service Pack 1 are visible. After installing ArcSDE 9.3 SP1, I ran the post installation utility and upgraded the geodatabases.
Does anyone know what else we can try? Should we try to upgrade to 9.3.1? If so, where can I obain a copy of ArcGIS Engine Runtime 9.3.1?
Full text:
ServerName: PremierOne_01_GIS
LoggerName: pswgs.gis
Level: CRITICAL
ErrorCode: 794040913595727872
Message: Open SDE workspace 172.25.100.50\Premierone, sde:sqlserver:172.25.100.50\Premierone, GISSDE_DATASET_A, S-P1-GISSDE-Reader, sde.DEFAULT error.
Has Been Logged: False
Original Fault ID: 1d2ba46e-781c-4c39-8d18-b6feebf61492
Message Key:
Error Code: 0
Application Name:
Logger Name:
Inner Exception:
PSWGS.GIS.Geospatial.GeospatialException: Could not open SDE geodatabase using connection properties: 'PSWGS.GIS.GisCommon.SdeDirectConnectionProps') ---> System.Runtime.InteropServices.COMException (0x800501C2): ArcSde Direct Connect driver release isn't compatible with ArcSde database instance release[Incompatible ArcSde direct connect driver/ database instance release. A]
at ESRI.ArcGIS.Geodatabase.IWorkspaceFactory.Open(IPropertySet ConnectionProperties, Int32 hWnd)
at PSWGS.GIS.Geospatial.SdeWorkspaceManager.TryOpenSDEWorkspace(SdeDirectConnectionProps connectionProperties) in c:\b\68\189\Sources\Product\GIS\Development\Common\Software\ProductCode\GeospatialCommon\Geospatial\SdeWorkspace\SdeWorkspaceManager.cs:line 517
--- End of inner exception stack trace ---
at PSWGS.GIS.Geospatial.SdeWorkspaceManager.TryOpenSDEWorkspace(SdeDirectConnectionProps connectionProperties) in c:\b\68\189\Sources\Product\GIS\Development\Common\Software\ProductCode\GeospatialCommon\Geospatial\SdeWorkspace\SdeWorkspaceManager.cs:line 553
at PSWGS.GIS.Geospatial.SdeWorkspaceManager.OpenSDEWorkspace(SdeWorkspaceInfo sdeWorkspaceInfo) in c:\b\68\189\Sources\Product\GIS\Development\Common\Software\ProductCode\GeospatialCommon\Geospatial\SdeWorkspace\SdeWorkspaceManager.cs:line 461