Issues retreiving data with microsoft SQL server Spatial reader

kavi88 — Thu, 13 Oct 2022 09:57:10 GMT

Hi,

Microsoft SQL Server Spatial reader connects successfully to a SQL Server entreprise geodatabase however it fails to retreive spatial data,throwing this error :

Microsoft SQL Server Spatial Reader: Failed to load mssql_spatial_wrapper.dll. Cannot read/write curves and full globe and may orient geography incorrectly. Ensure Microsoft System CLR Types for SQL Server 2012 and Microsoft .NET Framework 4.5.2 (or higher) and are installedMicrosoft SQL Server Spatial Reader: Microsoft System CLR Types for SQL Server 2012 is available at http://www.microsoft.com/en-ca/download/details.aspx?id=29065. Please expand 'Install Instructions' and download 'SQLSysClrTypes.msi'

Microsoft SQL Server Spatial Reader: If you have confirmed that Microsoft .NET Framework 4.5.2 (or higher) is not installed, it is available at http://www.microsoft.com/en-ca/download/details.aspx?id=42643

Microsoft SQL Server Spatial Reader: Schema lookup query failed for table `domain\TableName'. Provider error `(-2147217900) Incorrect syntax near '\'.'

Microsoft SQL Server Spatial Reader: Failed to retrieve schema information for feature type `domain\TableName'

I am using Arcgis Data Interoperability extension (FME 2021.1.2.0 (20210903 - Build 21627 - WIN64)) with ArcGIS pro 2.7, both in 64 bits, i have Microsoft SQL Server 2012 Native Client , Microsoft .NET Framework 4.5.2, ans also Microsoft OLE DB Driver 19 for SQL Server.

I have copied the mssql_spatial_wrapper.dll to C:\Windows\System32 and to C:\Windows\SysWOW64.

Any ideas please ?

Thank you in advance.

@BruceHarold @RenatoSalvaleon3

Re: Issues retreiving data with microsoft SQL server Spatial reader

BruceHarold — Thu, 13 Oct 2022 13:45:18 GMT

Hi Suzy, I see a lot of threads on the web with different issues, please log a support call so the analyst can follow up. I haven't seen this issue but it has been a while since I had Pro 2.7 on a machine.

topic Issues retreiving data with microsoft SQL server Spatial reader in ArcGIS Data Interoperability Ques.

Issues retreiving data with microsoft SQL server Spatial reader

Re: Issues retreiving data with microsoft SQL server Spatial reader